You need to build indexes.
>Thanks for your quick reply, do you mean Ms. SQL will generate automatically index or it will automatically find the existing index then use it? TIA
>
>Teddy
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com