Re: Creating indexes on a large table

prmail_at_gmail.com wrote:
> Creating indexes on a large table
>
> Hi,
> I have 2 large tables on which we have to create indexes.
>
> Table 1: ( Contains 4 Billion Records )
>
> Col 1 : Col 2 ( Datatype Number (10) )
>
> Table 2 ( Contains 1 Billion Records )
>
> Col 3 : Col 4 : Col 5 ( Datatype Number (10) )
>
> What is the most efficient way to create indexes on all the columns. I
> would be using all the columns separately in queries.
>
> Thanks !

Insufficient information.

Oracle version and edition?
Cardinality of the data?
Any existing constraints on the columns? What SQL statements will be run against the tables? How often is DML performed? What is the transaction load per second?

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)