Hi, Following on from what Mike mentioned, indexing all columns does not really help as MySQL will at most use one index for a query, so its important to pick your indexes carefully and consider constructing composite indexes. An index on a single column may not even be used due to poor cardinality.
Ewen On Fri, Sep 5, 2008 at 9:27 PM, 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 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
