|
|
Posted by Doug on 03/24/06 18:43
for help looking at creating indexes, look at the where clauses in your
select statements.
Find things that are pretty unique, or at least define what you want
down pretty closely.
Dates are usually good. Male/Female or Yes/No is really bad.
Don't be shy about using composite indexes, but the order of things in
your composite index can be important.
Navigation:
[Reply to this message]
|