As your table grows your inserts will start to get slower and slower. You run into the issue of locking a table due to re-creating the indexes. Also wasted space for indexes
On 9/5/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: > > Hi all, > > I am looking for, is there any specific reason for not indexing all columns > of a table. whats the impact on the performance. Although indexing is meant > for getting great performance. So, why indexing all columns is not > feasible. (Read in docs that all columns should not be indexed) > > -- > > Krishna Chandra Prajapati >
