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
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
