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