Indexes in SQL are mostly with the WHERE clause and the JOINed clause. These operations will go faster with good indexes.
>Thanks for your quick reply, you mean that I have to change the open "Table" statement to open "Select * from blahblah where blah blah = ..." ? if "Yes".. my question is how about the indexes that I created ? are they automatically use by the system regarding my "Order by .." statement .. ? or if "Not" how to use it .. ?
>
>TIA
>
>Winan
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com