Home » Developer & Programmer » Data Integration » Fastest method for creating indexes
Fastest method for creating indexes [message #92871] Thu, 29 November 2001 14:01 Go to next message
meena
Messages: 36
Registered: December 2000
Member
Hi All,

What is the fastest way to create indexes on a fact table with say 8 million rows?

Are there any efficient utilities to do this?
Thanks,
Meena

----------------------------------------------------------------------
Re: Fastest method for creating indexes [message #92904 is a reply to message #92871] Thu, 14 February 2002 02:06 Go to previous message
veera
Messages: 5
Registered: February 2002
Junior Member
Create index without logging parameter,I mean please specify nologging parameter in index creation time.Because archiving in not performed in index creation time.
With nologging parameter index creation time very less than create with logging parameter.
Previous Topic: Block Size
Next Topic: fine grain
Goto Forum:
  


Current Time: Thu Mar 28 17:45:57 CDT 2024