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