Creating indexes on a large table

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 ! Received on Mon Aug 01 2005 - 15:54:39 CDT