List:General Discussion« Previous MessageNext Message »
From:<daniel Date:June 1 2003 5:28am
Subject:Re: indexes question
View as plain text  
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



Thread
indexes question(Daniel Rossi)1 Jun
  • Re: indexes questionDan Nelson1 Jun
    • Re: indexes questiondaniel1 Jun
      • Re: indexes questionDan Nelson1 Jun
  • Inserting data?trogers1 Jun
    • Re: Inserting data?Becoming Digital1 Jun
      • Re: Inserting data?trogers1 Jun
        • Re: Inserting data?Becoming Digital2 Jun
          • Re: becoming unconfusedtrogers2 Jun
            • Re: becoming unconfusedBecoming Digital2 Jun
              • Re: becoming unconfusedtrogers2 Jun
              • Re: becoming unconfusedtrogers2 Jun
          • Re: Inserting data?Nils Valentin2 Jun