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