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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only