| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Alex Schaft | Date: | October 11 2011 7:41am |
| Subject: | Index question | ||
| View as plain text | |||
If you have a table with columns A & B, and might do a where on A or B, or an order by A, B, would single column indexes on A and B suffice or would performance on the order by query be improved by an index on A,B? Thanks
| Thread | ||
|---|---|---|
| • Index question | Alex Schaft | 11 Oct |
| • Re: Index question | Johan De Meersman | 11 Oct |
| • Re: Index question | Neil Tompkins | 11 Oct |
| • Re: Index question | Rik Wasmus | 11 Oct |
| • Re: Index question | Alex Schaft | 11 Oct |
| • Re: Index question | Alex Schaft | 11 Oct |
| • Re: Index question | Rik Wasmus | 11 Oct |
| • Re: Index question | Neil Tompkins | 11 Oct |
| • Re: Index question | Rik Wasmus | 11 Oct |
| • Re: Index question | Johan De Meersman | 11 Oct |
| • Re: Index question | Tompkins Neil | 11 Oct |
| • Re: Index question | Johan De Meersman | 12 Oct |
| • Re: Index question | Arthur Fuller | 11 Oct |
