Faster index creation

From: Tom <>
Date: Wed, 14 May 2008 08:02:03 -0700 (PDT)
Message-ID: <>

I need to create 2 indexes on a 107 GB table. The indexes have no columns in common. I have a 8 Gig SGA.

I am not looking forward to 2 tablescans so I was thinking of running both create index statements at the same time from different sqlplus sessions and hoping that the data for the slower statement is in cache for the faster statement.

Or as an alternative, I was thinking of first creating an index which was a superset of the columns in the other 2 indexes and then creating the other indexes. They will just use the first index instead of doing table scans. When they are done, drop the first index.

I'm hoping that someone else has better ideas or that there is just a simpler way.

. . . Tom Received on Wed May 14 2008 - 10:02:03 CDT

Original text of this message