| Fastest method for creating indexes [message #92871] |
Thu, 29 November 2001 14:01  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
