Re: To index or not to index

After the size of table rule, what you have to guess is Will the majority of the querys hit only 10% or less of the data? If so index is faster, else full table scans will be faster.

Your response will vary.

Gary England (gengland_at_hiwaay.net) wrote:
: D Morrow wrote:
: >
: > A while back there was a posting about size of tables and indexing. I
: > thought it had mentioned that a small table (about 1000 rows) was just on
: > the edge of needing an index??
: >
: > My question is: any general guidelines on when to create an index for a
: > table
: >
: > thanx in advance
: > Donna
 

: Other than for "required" fields like primary keys, and columns
: participating in referential integrity, it all comes down to
: performance.
 

: Additional indexes speed some reads, but slow all writes. Trial and
: error is typically the rule.

--
This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.