Re: indexing issue

From: joel garry <>
Date: Fri, 21 Mar 2008 10:29:18 -0700 (PDT)
Message-ID: <>

On Mar 20, 10:04 pm, 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!

This is a big subject. I suggest you check out after reading the concepts manual, and perhaps the data warehousing manual.

And after all that, you need to test for your particular situation. In my situation, I've found it is quicker to load the data then create the index, but oftentimes I'm dealing with thousands of tables and just letting imp do it's thing uses less of my time.

Don't forget to account for statistics recalculation.


-- is bogus.
Stay between the lines.  The lines are your friends.
Received on Fri Mar 21 2008 - 12:29:18 CDT

Original text of this message