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??

(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?

Thanks.....Rich