Re: multicolumn indexes, yes or no

2006-09-21 Thread Surendra Singhi
Hi Dan, "Dan Buettner" <[EMAIL PROTECTED]> writes: > The answer is - "it depends". > Thanks for your suggestions. > A multi-column index can be helpful for performance over single-column > - or it can do you no good at all, depending on how you build it and > how you use it. > > MySQL currently

Re: multicolumn indexes, yes or no

2006-09-20 Thread Dan Buettner
Surendra - The answer is - "it depends". A multi-column index can be helpful for performance over single-column - or it can do you no good at all, depending on how you build it and how you use it. MySQL currently uses (at most) one index per instance of a table per query. This means that addin