Problem with a select distinct

Posted on 16th Feb 2014 07:03 pm by admin

I have a problema with a select distinct, I have the next sql:

select distinct a,b,c,d from (select a,b,c,d,e,f...from table where ...)

The subselect have 25000 rows, it last about 10 seconds, but the select distinct over the subselect takes a long time..., I have waited for 20 minutes, and finally canceled the sql.

When I make this alternative path:

create table2 as (select a,b,c,d,e,f...from table where ...)
select distinct a,b,c,d from table2

The distinct finish in 5 seconds.

I don't understand the differences.... I can't do the alternative path, I need the first sql to work.
I don''t know where is the problem

Any advice will be greatly appreciatted

Your Answer:

Login to answer

Other forums

Needing Youtube thumb nail fix.
I have a script on a site that pulls in you-tube videos,
The problem is, that the thumb nails for

Database/Table Collation
What is the Database, and table collations used for? i don't understand what there used for since co

contact form - output to page and email
I have the following in my controller:

$message['name'] = htmlentities(strip_tags(trim($_POST

How to create a static html menu from a database
Hi,

I have built a small cms which allows me to create simple html pages and then upload them

Login Issue's
Code: <?php
$file = fopen('user.txt', 'r');

/* Set login to false initially */

FTP issues
Hi all,


I am currently facing some serious problems with a script and really need some ad

Do While statement
hi guys,

This may sound trivial but im new to php and as part of an assignmenti have to const

Read from forum
Haven't written anything forever and I would like to get back.
What I'm trying to do is getting t

Problem with umlauts and UTF-8
Hello every1,

I'm creating my own little CMS at the moment and got some problems with the cha

Contact Form Not Working When I Add Validation Codes
So I built my first working PHP "Contact Us" like form. But, I have been trying to now mak