Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

Name

Index_Attributes_Clause

Synopsis

[Physical_Attributes_Clause]
[Storage_Clause]
[{LOGGING | NOLOGGING}]
[ONLINE]
[COMPUTE STATISTICS]
[TABLESPACE {Tablespace_name | DEFAULT}]
[{COMPRESS integer | NOCOMPRESS}]
[{NOSORT | REVERSE}]
[{PARALLEL | NOPARALLEL}]

Specifies a set of physical and logical characteristics of an index..

Keywords

Physical_Attributes_Clause

Specifies the physical attributes for the index; see the “Physical_Attributes_ Clause” entry later in this section.

Storage_Clause

Specifies the storage characteristics for the index. See the “Storage_Clause” entry later in this section.

ONLINE

Specifies that DML operations on the indexed table will be permitted during index creation.

COMPUTE STATISTICS

Specifies that statistics will be collected during the creation of an index.

TABLESPACE

Specifies the name of the tablespace where this index will be stored. If you omit TABLESPACE, the default tablespace for the schema owner will be used. The keyword DEFAULT may also be specified.

NOSORT

Specifies that the rows being indexed were loaded in ascending order and do not have to be sorted during index creation.

REVERSE

Specifies that (except for ROWID) bytes of the index block will be stored in reverse order. This keyword cannot be used with NOSORT.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page