Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tuning index creation
The quickest way to save time is to create the index as 'unrecoverable'.
This will not generate redo and makes the whole operation a lot quicker.
hth
neil
NetComrade wrote in message <37bb1a69.20121872_at_news.earthlink.net>...
>Is there are anything besides NOSORT and SORT_AREA_SIZE that can be
>done to speed up index creation (PQO is useless if the index/table
>is/are on one disk I think)
>
>Thanx
>
>---------------
>Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 373-5417
>AOL: NetComrade ICQ: 11340726 remove NSPAM to email
>
Received on Fri Aug 20 1999 - 10:06:45 CDT