Re: indexing issue
Date: Fri, 21 Mar 2008 05:06:19 GMT
"Henry" <ggk517_at_gmail.com> 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