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?