>I have a table with fields
> AGENTCODE C 6
> CTRL_NUM N 6
> .
> .
>
>and an index tag using the expression
>AGENTCODE + STR(CTRL_NUM,6)
>
>
>(1) Are there any settings which would make a query such as
>SELECT * FROM myTable ;
> WHERE agentcode = "XXXXXX"
>
>be optimizable??
No. You need to exactly match the key. See my Rushmore article on my web site,
www.esolserv.com>
>(2) If an alias is used in a WHERE clause, will Rushmore be able to recognize it??? Assuming a second table with the same index tag would
>
>SELECT a.* FROM Table1 A, Table2 B;
>WHERE (a.agentcode+STR(a.ctrl_num,6) = (b.agentcode+STR(b.ctrl_num,6)
>
>be optimized?
Yes
>
>Thanks.....Rich
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer