Re: select count(distinct)
Posted by:
Jay Pipes
Date: July 07, 2005 10:51AM
BTW, I forgot the time to execute each of these queries (in order):
1) > 40 minutes (I killed the pid)
2) .03 sec
3) > 20 minute (again, I killed it)
4) 46 seconds.
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Got Cluster?
http://www.mysql.com/cluster
Personal:
http://jpipes.com
Subject
Views
Written By
Posted
97334
July 05, 2005 07:23PM
28764
July 05, 2005 07:37PM
22392
July 06, 2005 05:44AM
19292
July 07, 2005 06:13AM
17266
July 07, 2005 09:11AM
17308
July 07, 2005 10:48AM
Re: select count(distinct)
9998
July 07, 2005 10:51AM
8825
July 08, 2005 05:27AM
9928
July 08, 2005 05:48AM
8118
August 19, 2005 05:22AM
8983
July 06, 2005 02:11AM
8312
July 06, 2005 05:33AM
7336
July 06, 2005 06:13PM
7277
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.