Re: indexing issue
Date: Fri, 21 Mar 2008 16:55:58 -0700 (PDT)
On Mar 21, 1:04 am, Henry <ggk..._at_gmail.com> 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