Skip to Content
0
Former Member
Sep 26, 2011 at 06:29 PM

New Index on 550 Gb table - suggstions please

418 Views

Hello friends,

i have to create a new Index in Oracle 11g db for a table of size around 550GB. please give me your expert suggestions.

I have checked SAP Note 334224 and plan to do with SQl

Create the index using SQLPLUS with the following command:

create index <index name> on <table name> ( <field1, field2, ...> )

nologging tablespace <tablespace name>

parallel (degree <number>)

..........online;

questions:

1. How much Temp tablespace is required for this.

2. Any suggestions for parallel (degree <number>) parameter.. we have 4 CPU.

3. Should i use parameter nologging or complete nologging tablespace <tablespace name> ? does it have any problems ? Database is in archivelog mode.. and is it required for complete tablespace ?

thanks

ashish