Location: Database

Discussion: IndexingReported This is a featured thread

Category: Discussion Forum / General Discussion
Showing 2 posts

chettiarsandip
Indexing
Mar 2 2009, 4:59 AM EST | Post edited: Mar 2 2009, 4:59 AM EST
I am creating a table and then loading approx 1.5 million records into this table.

The insert statement that I use is something like this:

insert into tgt_tablename
select * from source_tablename

My question is: would it be advisable to create the index after the insert or before the insert.

I feel creating the index before or after the load will not cause any difference if the table is a new one.

Kindly advise.

Thanks Do you find this valuable?    
Keyword tags: None
luciofer
luciofer
1. RE: Indexing
Mar 2 2009, 11:00 AM EST | Post edited: Mar 2 2009, 11:00 AM EST
I guess little difference with so few rows...

-Create the index before loading, and you will have some IO overhead.
-Create the index after loading, and the creation time will do the compensation. Anyway this is my preferred.

For best performance in any case, create the table, insert the data using APPEND hint, then create the index.
(It's just a suggestion)

Cheers 1  out of 1 found this valuable. Do you?