Re: indexing issue
From: news.verizon.net <kennedyii_at_verizon.net>
Date: Fri, 21 Mar 2008 05:06:19 GMT
Message-ID: <fnHEj.16153$4q3.5177@trndny02>
Date: Fri, 21 Mar 2008 05:06:19 GMT
Message-ID: <fnHEj.16153$4q3.5177@trndny02>
"Henry" <ggk517_at_gmail.com> wrote in message
news:676f748e-fc68-4a67-9f20-ad9d6eea1db8_at_u72g2000hsf.googlegroups.com...
> 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