Re: indexing issue

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

This is a big subject. I suggest you check out http://richardfoote.wordpress.com 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.

jg

--
@home.com is bogus.
Stay between the lines.  The lines are your friends.
http://www.wired.com/politics/security/commentary/securitymatters/2008/03/securitymatters_0320