MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: Use of DISTINCT in INNER JOIN
Posted by: Steve Croall
Date: March 28, 2009 02:02AM

Ok, thanks. We will just have to be careful anywhere we use DISTINCT and JOINs.

I still don't know why it has to do a full table scan in order to process the DISTINCT on the two columns. Surely it has only to go through the result set generated by the JOIN.

Is it because the use of the DISTINCT clause causes the ON clause not to use the available index? Without DISTINCT the index is used.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Use of DISTINCT in INNER JOIN
66792
Steve Croall
March 24, 2009 12:07PM
Re: Use of DISTINCT in INNER JOIN
10901
Steve Croall
March 24, 2009 02:00PM
Re: Use of DISTINCT in INNER JOIN
6728
Rick James
March 25, 2009 07:01PM
Re: Use of DISTINCT in INNER JOIN
6439
Steve Croall
March 27, 2009 05:20AM
Re: Use of DISTINCT in INNER JOIN
5640
Rick James
March 27, 2009 10:01AM
Re: Use of DISTINCT in INNER JOIN
6611
Steve Croall
March 28, 2009 02:02AM
Re: Use of DISTINCT in INNER JOIN
4509
Rick James
March 28, 2009 03:53PM
Re: Use of DISTINCT in INNER JOIN
5702
Steve Croall
April 01, 2009 03:36AM
Re: Use of DISTINCT in INNER JOIN
5979
Rick James
April 02, 2009 12:16AM
Re: Use of DISTINCT in INNER JOIN
5445
Steve Croall
April 02, 2009 06:29AM


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.