You don't need to care about indexes! When you query the database, the engine will use correct indexes without your help.


>Hi.. I'm very new for VB6.. currently I use ADO 2.7 Enginee and Ms. SQL as my database, I have created the database, tables also the Indexes .. my problem is how to use the index .. please give me example .. thanks
>
>Teddy