-
Do we need to rebuild indexes after insert /*+APPEND
Hi,
I'm loading a large table with Insert /*+APPEND, the table has many indexes on it. Do I have to rebuild the indexes after the load or will they adjust automatically.
Thanks
Jay
-
Perform an insert /*+ append */ and see if the indexes are rendered unusable according to the user_indexes table.
-
I did a small test, they are in VALID state, but would I still need to (or have to) rebuild them?
Thanks
Jay
-
Nope. you'd rebuild them as a solution to a well-defined performance problem or to move them to a new tablespace, but otherwise leave them be.
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
|