Re: To index or not to index

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. Received on Mon Sep 29 1997 - 00:00:00 CDT