Re: indexing issue

From: <>
Date: Fri, 21 Mar 2008 05:06:19 GMT
Message-ID: <fnHEj.16153$4q3.5177@trndny02>

"Henry" <> wrote in message
> 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!

Why drop the table in either case? Please explain what business problem you are trying to solve. In a lot of data warehouse environments they drop the indexes and load the table and build the indexes. Jim Received on Fri Mar 21 2008 - 00:06:19 CDT

Original text of this message