Re: Index Slot to Create

Mark Schenkel wrote:
>
> Index Slow to Create
>
> I have a table with 9000 records and a column 40 wide. Attempting to
> create an index on this table against this field takes upward of about
> 7 minutes (on a pentium 500). In past times creating indexes on this
> same table (with approximately the same amount of data) has not taken
> nearly as long. The tablespace in which the table belongs has ample
> space free (~200MB). When the index is being created I can hear the
> hard drive on the server doing a lot of work. I am very surprised why
> this is now taking so long to create a simple index. Are there
> temporary tablespaces I need to be concerned about?
>
> Any help would be greatly appreciated.
>
> Mark.

You might want to crank your sort_area_size to avoid the disk activity...also 'nologging' will assist

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse