Hi Ricardo,

Ricardo Conrado Serafim wrote:
Hi Group!

I've a doubt about indexes and I hope that you can help me.

If I've a table index with 5 columns (col_1,col_2,col_3,col_4,col_5) and I do a query where the clause "where" use just col_1, col_2, col_4 and col_5.
This query will use the index at least with the col_1 and col_2??

It depends.  When in doubt, use EXPLAIN to see if the index is being used.

Cheers
Baron

--
Baron Schwartz
http://www.xaprb.com/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to