Re: select distinct slower in 5.0 than 4.1
If you already have a unique constraint on (pid,lastname), is there a need of the distinct in your select when you have a where condition with = on the lastname?
The distinct seems to be redundant and it makes MySQL do extra work to check for duplicates when there will not be any.
Subject
Views
Written By
Posted
3752
December 18, 2005 12:24PM
2811
December 19, 2005 10:49AM
2549
December 20, 2005 10:29AM
2497
December 20, 2005 11:36AM
2460
December 21, 2005 01:54AM
2389
December 20, 2005 08:29PM
2459
December 21, 2005 03:15AM
2523
December 29, 2005 01:55AM
Re: select distinct slower in 5.0 than 4.1
2410
December 27, 2005 06:49PM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
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.