Re: How to speed up CREATE INDEX

Andreas Wizemann wrote:
>
> Hi,
> i need to create multiple indexes on very large tables.
> Currently i do this one by one, which takes a lot of time.
> How can i speed up this process ?
> Is there a way to do something in parallel ?
>
> Regards
> Andreas
> Andreas Wizemann

For each index, look at:

• using a higher sort area size
• using nologging
• using the parallel option in create-index

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."