Ed Leafe wrote: > On Nov 4, 2007, at 9:17 AM, MB Software Solutions wrote: > > >> Excellent tips...thanks. I recall TR telling some time ago something >> about how if you had an index on 'a', 'b', and 'a+b', MySQL would not >> necessarily use 'a+b' when necessary but instead use just 'a'. >> > > If you want to have both a and b in the index, you don't want a+b; > you want (a, b). >
Right...I didn't mean to concatenate...that was just implying that I was using both together in the index. -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
