I am trying to create an index on 1 primary key on a partitioned table. As the table contains over billion rows - as you expect - it takes ages to create an index.

At the moment, I am creating a global index rather than that of local for partitions.

Can anyone tell me what is the best way to create an index for such large table?

Thanx in advance
Fiona
x