Re: [PERFORM] When NOT to index small tables?

2003-08-20 Thread Bruno Wolff III
On Wed, Aug 20, 2003 at 13:01:16 +0300, [EMAIL PROTECTED] wrote: > I have found many reasons not to index small tables (see . > But I still have questions. > > 1. How small is small enough? Unless you think maintaining the indexes is a significant overhead, you shouldn't worry about it as the p

[PERFORM] When NOT to index small tables?

2003-08-20 Thread alvis
I have found many reasons not to index small tables (see . But I still have questions. 1. How small is small enough? 2. am I supposed to drop primary key index on so called 'label tables' knowing I am using this pk in join clause? 3. Is it good to drop index on small table If I know I have created