Hello,
are these statements true:
- «You should always index fks. The only exception is when the
matching unique or primary key is never updated or deleted» ?
- «Small tables do not require indexes» ?
- «Create an index if you frequently want to retrieve less than
about ~15% of the rows in a large table»
- «Index only columns with unique values, or only with a few
duplicates»
Is it necessary to run ANALYZE on the table after any index creation to
gather statistics about the index/column?
Thanks
Bruno Lavoie
|
