[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: doubt about indexes
From:       Baron Schwartz <baron () xaprb ! com>
Date:       2007-05-29 20:11:20
Message-ID: 465C88E8.40704 () xaprb ! com
[Download RAW message or body]

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/mysql?unsub=mysql-marcsub@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]