Fastest way to create new table based on a view?
From: <PGSCHMID_at_bcsc02.gov.bc.ca>
Date: 1996/01/26
Message-ID: <1771AD275S86.PGSCHMID_at_bcsc02.gov.bc.ca>#1/1
Date: 1996/01/26
Message-ID: <1771AD275S86.PGSCHMID_at_bcsc02.gov.bc.ca>#1/1
I'd like to create a new table based on a view which contains a join
of several tables. What is the fastest way to perform this without
writing the view rows to an OS file and using SQL*Loader to load the
new table?
So far the SQL*Net COPY seems to be fastest. The new table
will contain approx 500,000 rows. We are running a read-only Data
Warehouse environment so I don't care if the new table is recoverable.
Thanks.
Petr Schmidt
pgschmid_at_bcsc02.gov.bc.ca
Received on Fri Jan 26 1996 - 00:00:00 CET