| 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 question | Dan Nelson | 1 Jun |
| • Re: indexes question | daniel | 1 Jun |
| • Re: indexes question | Dan Nelson | 1 Jun |
| • Inserting data? | trogers | 1 Jun |
| • Re: Inserting data? | Becoming Digital | 1 Jun |
| • Re: Inserting data? | trogers | 1 Jun |
| • Re: Inserting data? | Becoming Digital | 2 Jun |
| • Re: becoming unconfused | trogers | 2 Jun |
| • Re: becoming unconfused | Becoming Digital | 2 Jun |
| • Re: becoming unconfused | trogers | 2 Jun |
| • Re: becoming unconfused | trogers | 2 Jun |
| • Re: Inserting data? | Nils Valentin | 2 Jun |
