Parallel: allows you to perform an index operation using multiple processes
rather than the default of one. Should lead to faster index creation for
large data volumes.
Nologging: Operation does not generate redo. Also means you wont be able to
recover it from backup, so set the index back to logging after creation and
do a database backup immediately.
Compress: will compress the index making it consume less disk space. The
claim is that this will save space but not impact query time. I suggest you
test this though!
HTH
-----Original Message-----
From: sandeep3
[mailto:oracledba-ezmlmshield-x56660406.[Email address protected]
Sent: 30 November 2005 04:58
To: LazyDBA Discussion
Subject: meanings of different clauses in index creation statements
>
> Can some one explain the meaning of clauses parallel, nologging
> and
> compress
>
> create index <index name> on <table name> (<column names>)
> tablespace <table space name> parallel (degree 4) nologging
> compress 5;
>
> Sandeep Saxena
>
ForwardSourceID:NT000221EA
Notice: The information contained in this e-mail message and/or attachments
to it may contain confidential or privileged information. If you are not
the intended recipient, any dissemination, use, review, distribution,
printing or copying of the information contained in this e-mail message
and/or attachments to it are strictly prohibited. If you have received
this communication in error, please notify us by reply e-mail or telephone
and immediately and permanently delete the message and any attachments.
Thank you
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
-----------------------------------------
Information in this email may be privileged, confidential and is intended
exclusively for the addressee. The views expressed may not be official
policy, but the personal views of the originator. If you have received it
in error, please notify the sender by return e-mail and delete it from your
system. You should not reproduce, distribute, store, retransmit, use or
disclose its contents to anyone. Please note we reserve the right to
monitor all e-mail communication through our internal and external
networks.
Oracle LazyDBA home page