Re: indexing issue

From: hpuxrac <>
Date: Fri, 21 Mar 2008 16:55:58 -0700 (PDT)
Message-ID: <>

On Mar 21, 1:04 am, Henry <> wrote:
> Hi guys,
> Which is the recommended way of creating index?
> May i know is there any difference between :-
> 1) drop & recreate table+indexes and then populate the table.
> 2) drop table, populate the table and then create the index.
> Thanks a lot!

You don't really supply enough information.

Using oracle partitioning might be one option.

Truncating the table and (perhaps ) dropping indexes if the application downtime window support it followed by a direct sqlldr run then re-creating indexes is another. Or perhaps just truncate table followed by data load while leaving indexes around? It all depends .. Received on Fri Mar 21 2008 - 18:55:58 CDT

Original text of this message