-
I've heard that it's best to create an index on an empty table before loading the table via sqlldr.
Fact/Fiction or does it depend on the data? Any tips will be appreciated.
-
Hi,
You should create the index after the data is loaded. This will ensure a balanced index tree to start with.
Also create the index when there is low system activity.
Baliga
-
Absolutely wait until the table is populated, as mbaliga stated. Not only because of the balanced tree issue, which is *very* important, but also because it is faster to process.
Create Index
Load data
Analyze
is SLOWER than
Load data
Create Index
Analyze
- Chris
-
it's basically because index is a independant segment therefore if you create index first then load data you would essentially inserting *twice*, both data & index segments
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|