select distinct slower in 5.0 than 4.1
I have the following very simple statement:
select distinct(PID) from lastnames where name = 'Smith'
The table has only two columns, PID and name. It has a BTREE index on the name column, and a unique contraint on the PID, name columns combination. The storage engine is MYISAM.
On 4.1.16 this query runs very fast. Using the EXPLAIN SELECT I see that the 'type' of the query is 'ref'.
On 5.0.16 this query runs very slow (about x20 times slower). EXPLAIN SELECT show that the 'type' of the query is 'range'.
Could that be related to the loose index scan feature of 5.0?
Have I forgotten anything when doing the migration?
Thanks,
Saar
Subject
Views
Written By
Posted
select distinct slower in 5.0 than 4.1
3404
December 18, 2005 12:24PM
2648
December 19, 2005 10:49AM
2371
December 20, 2005 10:29AM
2314
December 20, 2005 11:36AM
2297
December 21, 2005 01:54AM
2219
December 20, 2005 08:29PM
2290
December 21, 2005 03:15AM
2365
December 29, 2005 01:55AM
2259
December 27, 2005 06:49PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.