Re: Creating indexes on a large table

dasdipa_at_zeus.franklin.edu (Dipankar) wrote:

>I am trying to create an index on 2 columns of a large table
>( 8 million rows) after loading the data through SQL*Loader.
>This process was taking days together. Running ORACLE 7.1.4
>on NT server. Database is of 9.5 Gig out of 10 Gig available
>on the machine. SGA is of 24 MB out of 100 MB total memory.

I don't think you can do this any faster. The RDBMS has to scan the table in order to build the index tree. The only thing that I can think of is to create the index first and then do the load. Loader commits chunks of the data file and the extra overhead in updating the index tree would be less significant than waiting for it when the table is 8 million rows in size. I guess it's a bit too late for that now. Obviously this is always a problem in changing your mind about indexes on an existing database.

+------------------------------------------------------------+
|   Mike Philippens - Gorinchem - The Netherlands, Europe    |
|                 Vijfhart Automatisering bv                 |
|       Oracle Specialists Training and Consultancy          |
|                 Utrecht    The Netherlands                 |
+------------------------------------------------------------+