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

Sort a two dimensional array.
Hi. I've set up a two dimensional array that reads as follows:

Code: $modifiedData = array(

CU&UC guide
Hi Gurus,

can anybody provide me the link for CU&UC upgrade guide

Thanks i

Help with setcookie()
Merry Xmas to those on this foruum
Older guy here with some experience but not allot so please be

mysql_real_escape_string
Let me preface this that I am very much a PHP noob, but I have some SQL training (not necessarily My

PHP and MySQL Question/Help
I have a MySQL db with all my servers and all their details like server name, IP, OS, RAM etc etc 26

Showing selected item at top of list
Hi,

I've got a list of names which i am fetching from database like this:
$qry = db_query

COde for a Cc
I'm not receiving $ft as a Cc. Why is that??

$to = "$email";
$headers = "Fr

How to secure my login data to my database?
Hi there,

It may be a stupid question but I don't know how to secure my login data to my data

Upload file and add HTML
Hey everyone,

I have a client has meeting agendas and minutes that should be posted online. I

moving mouse to display image coordinates
I have an existing MFC application that shows an image in the main window.
I'd like to be able to