In the last episode (Sep 06), Jason Pyeron said:
> there is an unique key index 'pathref_2 (pathref,version)' on this
> table.
>
> so why does 'explain select * from files where
> (pathref,version)=(129286,0);' scan the whole table?
I have to admit I have never seen this syntax used in a where clause
before. Does "where pathref=129286 and version=0" optimize any better?
A quick test of mysql-5.0.11 indicates that it doesn't use indexes at
all with the (field1,field2,..)=(value1,value2,..) syntax. Feel free
to file a bug :)
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
