I would Disable the indexes and then re-enable them
--
-Nandeep
Database consultant
NOTE:
This is a digitally Signed message by Nandeep .Click the Digital Signature
Icon. and confim Non-Tampering
"harry" <a_at_abc.com> wrote in message
news:nhtv4u0koeahbec0jl0gbarhs9e41k98s4_at_4ax.com...
> Using Oracle 8i on NT Server 4 (sp6a)
>
> I have a table that gets populated from scratch every week or so using a
"CREATE TABLE tablename as
> SELECT ..." statement.
>
> As the table is very large its a bit tricky to try all different speed
tests on it so I was
> wondering if somebody could tell me if this is the quickest way to do
this?
>
> Should I -
>
> 1. use a "TRUNCATE TABLE" statement & use a "INSERT INTO" instead? - will
the indexes automatically
> be dropped aswell? - I don't want them active when doing an INSERT - do I
have to recreate them
> after?
>
> 2. Use "DROP TABLE tablename cascade constraints" statement? - does this
remove indexes aswell?
>
> 3. any other ideas?
>
> Many thanks
>
> HArry
>
>
Received on Thu Jan 24 2002 - 13:17:05 CST
