Etienne Marcotte wrote: > What is the exact difference between > this > index(col1,col2).
Create a single index on col1 and col2. > > that > index(col1),index(col2). Creat two indexes, one on col1, one on col2. > > and this > index(col1),index(col2),index(col1,col2). Do all three. Note that index(col1) is covered by index(col1, col2). b. mysql --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
