List:General Discussion« Previous MessageNext Message »
From:Daniel Rossi Date:June 1 2003 4:46am
Subject:indexes question
View as plain text  
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 ?



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