Re: Creating Index on 7 million row table!
Date: Wed, 02 Jun 1999 18:57:22 GMT
Message-Id: <slrn7lavpc.fa.joel-garry_at_home.com>
On Mon, 31 May 1999 01:56:55 GMT, Carol Kilner <ckilner_at_protectair.com> wrote:
>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.
It sounds about 3 to 10 times too slow. How big is your SGA? Are you seeing any swapping? Archivelogging interval? Other thingss going on at the same time? Any strange jobs taking up lots of I/O or CPU time?
>
>- 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
>
>
>
>
jg
-- These opinions are my own. http://ourworld.compuserve.com/homepages/joel_garry Remove nospam to reply. mailto:joel-garry_at_nospam.home.com Oracle and unix guy.Received on Wed Jun 02 1999 - 20:57:22 CEST