Creating Index on 7 million row table!
From: Carol Kilner <ckilner_at_protectair.com>
Date: Mon, 31 May 1999 01:56:55 GMT
Message-ID: <H%l43.33445$tE.158858_at_news2.rdc1.on.home.com>
I have to create a single index on a single column in a table that contains approximately 7 million rows. I just completed the job and it took about 30 hours to complete. Is this reasonable given the following conditions, or is there someway to speed this up.
Date: Mon, 31 May 1999 01:56:55 GMT
Message-ID: <H%l43.33445$tE.158858_at_news2.rdc1.on.home.com>
I have to create a single index on a single column in a table that contains approximately 7 million rows. I just completed the job and it took about 30 hours to complete. Is this reasonable given the following conditions, or is there someway to speed this up.
- Machine is a High end Sun solaris box with lots of memory (1Gig) and lots of Disk space
- Running Oracle 8
- Field to index is not sorted and is about 18 characters (Vehicle Identification Numbers)
- The index is in a tablespace that is different from the data and the temporary tablespace and also located on physically different disks.
- I used the nologging option when creating the index. I use a large initial extent.
- Sort size is fairly large
Is there anything else I can do to make dealing with this index less painful, short of having the data loaded into the table already in sorted order (which I'm not sure if possible!).
Any suggestions would be greatly appreciated! Thanks,
Carol Kilner
ckilner_at_protectair.com Received on Mon May 31 1999 - 03:56:55 CEST