Hello !
My questin can be too general, but I am generally having trouble deciding 
what field/fields should be indexed in a database.? PrimaryKey field is an 
obvious choice but.? (For SQL Server 2000 and MS Access 2000)

The field(s) that you key on and access most in the WHERE clause
WHERE  a =3D 123      b=3D"abc"   a > 123    a < 123   IN is OK
But do not index is you are going to use LIKE
WHERE streetaddr LIKE "%elm%"

DB has no bearing

-----Original Message-----
From: Chirag Shah [mailto:chiragiit@y...]
Sent: Sunday, May 26, 2002 10:58 AM
To: ASP Databases
Subject: [asp_databases] factors deciding good index


Hello !
My questin can be too general, but I am generally having trouble
deciding
what field/fields should be indexed in a database.? PrimaryKey field is
an
obvious choice but.? (For SQL Server 2000 and MS Access 2000)