Re: Alternate Indexes

In article <34B501B8.CE0E060D_at_csc.com>, Syed Ali <sali1_at_csc.com> wrote:
>I have an alternate index defined on a large table (3.6 million rows). I
>load data in this table using SQL*LOADER utility in DIRECT Load mode.
>The index is automatically loaded after the data has been loaded. Which
>is a better approach ? Create index after the data load or create index
>before data load in DIRECT load mode (as I am doing) ? Does it even
>matter when you load the data using DIRECT load mode ?

create the index later.

>
>I'll appreciate any response.

Probably get better response in comp.databases.oracle.server.

>S A
>

-- 
These opinions are my own and not necessarily those of Information Quest
jgarry_at_eiq.com                           http://www.informationquest.com
http://ourworld.compuserve.com/homepages/joel_garry
"See your DBA?"  I AM the _at_#%*& DBA!