Do we need to rebuild indexes after insert /*+APPEND

[Nugpot]

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

[slimdave]

Perform an insert /*+ append */ and see if the indexes are rendered unusable according to the user_indexes table.

[Nugpot]

I did a small test, they are in VALID state, but would I still need to (or have to) rebuild them?

Thanks
Jay

[slimdave]

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.