What indexes do you have for table1 and table2?
>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?
>
>Hope that was clear!
--sb--