>How come my queries are not optimized?
>
>Lets say I have 2 tables, each with a field containing an id (sys(2015)), If I run a select statement :
>
>Sele * from table1,table2 where table1.id = table2.id
>
>and both id fields in these tables are optimized, it says rushmore optimization is none?
In order for Rushmore optimization to work fully, you need to have an unfiltered index on both table expressions - if an iondex has a filter on it (such as
FOR ! DELETED()) the index will not be used for optimization. If the index is not a part of the structural CDX, you must have opened the file with the .IDX file named in the USE or SET INDEX TO prior to the query being performed; .IDX files are not automatically associated with their original tables.
You need to use the same expression in the index as is used on the SELECT as well.