Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle SQL Condition Question...
Ajay Kulkarni escribi :
>
> To improve the processing time use the following query
>
> insert into tab3
> select f1 from tab1
> minus
> select f2 from tab2
I'm afraid that Bhavesh wants to insert all columns of tab1, not only f1.
Anyway, you haven't told us if you've got any index in tab3. If so you should drop them and re-create them after the insert operation.
Regards.
-- Julio Negueruela DBA Servicio Inform tico Universidad de La Rioja - Spain Telf: 941-299179 Fax: 941- 299180 mailto:julio.negueruela_at_si.unirioja.esReceived on Thu Apr 23 1998 - 00:00:00 CDT