Re: *** SQL Problem, please help ***
On 25 Feb 1997, Belakimem wrote:
> The second of the folowing SQL's takes forever.
> select distinct a from b where x = y into temp temp_table;>
> insert into c select * from db1@unixbox1:d where> a in ( select a from temp_table );
>
I think you could try creating an index on temp_table
(create index i1 on temp_table(a) )
and change the second sql command to
insert into c select * from db1@unixbox1:d where
a in (select a from temp_table where db1@unixbox1:d.a = temp_table.a)
Hope this helps,
Cesar Souza - Brazil - casouza@usp.br