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
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com