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]