From: Dan Nelson
Date: June 1 2003 5:17am
Subject: Re: indexes question
List-Archive: http://lists.mysql.com/mysql/141323
Message-Id: <20030601051730.GE82881@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Jun 01), Daniel Rossi said:
> hi just reading up on optimising indexes, does it matter what order u
> set your indexes ?
> 
> The first index part should be the most used column. If you are
> always using many columns, you should use the column with more
> duplicates first to get better compression of the index.
> 
> i dont really understand what they meant by this ,  i use most the
> columns when searching but only a few of the columns which are
> fulltext get searched the most , do i add these indexes first then ?

That part of the manual is talking about a single multi-column index. 
If you have multiple separate indexes, it doesn't matter in which order
you create them.

-- 
	Dan Nelson
	dnelson@stripped