Re: To index or not to index

7602070a_at_MorrowD.ci.portsmouth.va.us> (Donna) asked >>  general guidelines on when to create an index for a table <<

Besides performance reasons
1) create an index to enfore data intgrity rules like no duplicates of the key column(s) value.
2) create indexes where database level refrential integrity rules will be defined, i.e., primary key, unique key, and foreign key constraints since defining FK in the database require that PK or UK constraints exist. 3) create indexes on small tables where the future growth is uncertain or not absolutely certain to be nill

Mark Powell -- The only advise that counts is the advise that you follow so follow your own advise Received on Mon Sep 29 1997 - 00:00:00 CDT