Re: indexing issue

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Fri, 21 Mar 2008 16:55:58 -0700 (PDT)
Message-ID: <2b3fc31f-0670-4d38-a3f8-703f624764d6@59g2000hsb.googlegroups.com>


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

Original text of this message