i have one multiple column fulltext index for 3 columns i join in a
fulltext match statement
> 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
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
