Make sure you have an index on id (and only id) for both tables.
Also, you may get different results if you change the setting for SET DELETED.
>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!
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer