View Single Post

   
  #1 (permalink)  
Old 03-07-2008, 02:29 PM
aaooo54
 
Posts: n/a
Default performance issue - group by, multiple fields

hello group

there is table1 with 5 fields: A,B...E definied as varchar(250), without
indexes and autonumber fields
i would like to create table2 with unique combination of fields
the simplest way is (imho) query:

create table table2
select A,B,C,D,E from table1
group by A,B,C,D,E;

but the query is not effective and takes a lot of time.
have you got any ideas how to speed up the process?


Reply With Quote