MySQL Forums
Forum List  »  Performance

Re: select count(distinct)
Posted by: heidi savin
Date: July 07, 2005 05:14AM

I did run it multiple times in a row and it doesn't make a difference. The select query that you proposed doesn't work because it just prints out a 1 for each occurence of the distinct col1 values. Thanks for the suggestion though. I guess I'll keep using my hack since it's significantly faster than the count(distinct ) method

Options: ReplyQuote


Subject
Views
Written By
Posted
96564
July 05, 2005 07:23PM
28552
July 05, 2005 07:37PM
22200
July 06, 2005 05:44AM
19089
July 07, 2005 06:13AM
17057
July 07, 2005 09:11AM
17061
July 07, 2005 10:48AM
9814
July 07, 2005 10:51AM
8664
July 08, 2005 05:27AM
9747
July 08, 2005 05:48AM
7954
August 19, 2005 05:22AM
8811
July 06, 2005 02:11AM
8124
July 06, 2005 05:33AM
7133
July 06, 2005 06:13PM
Re: select count(distinct)
7097
July 07, 2005 05:14AM


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.