Re: indexing issue

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!

No version number.
No information on table type.
No information on number of records in the table. No business problem being solved.

I've hear mauve has the most RAM. <g>

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org