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>)
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 ?