Amigos

[dbandre29 0]

Qual a sintaxe de index cluster , bitmap e outros que tem no Oracle e onde e que situações usa-los??

[alphamek 2]

Segue as sintaxes para você completa de todos os índices que o Oracle suporta até 9i.

 

CREATE INDEX

 

Create an index.

 

Syntax:

 

Table Index

CREATE [uNIQUE|BITMAP] INDEX [schema.]index_name

ON [schema.]table_name [tbl_alias]

(col [ASC | DESC]) index_clause index_attribs

 

Bitmap Join Index

CREATE [uNIQUE|BITMAP] INDEX [schema.]index_name

ON [schema.]table_name [tbl_alias]

(col_expression [ASC | DESC])

FROM [schema.]table_name [tbl_alias]

WHERE condition [index_clause] index_attribs

 

Cluster Index

CREATE [uNIQUE|BITMAP] INDEX [schema.]index_name

ON CLUSTER [schema.]cluster_name index_attribsindex_clauses:

 

LOCAL STORE IN (tablespace)

 

LOCAL STORE IN (tablespace)

(PARTITION [partition

[LOGGING|NOLOGGING]

[TABLESPACE {tablespace|DEFAULT}]

[PCTFREE int]

[PCTUSED int]

[iNITRANS int]

[MAXTRANS int]

[sTORAGE storage_clause]

[sTORE IN {tablespace_name|DEFAULT]

[sUBPARTITION [subpartition [TABLESPACE tablespace]]]])

 

LOCAL (PARTITION [partition

[LOGGING|NOLOGGING]

[TABLESPACE {tablespace|DEFAULT}]

[PCTFREE int]

[PCTUSED int]

[iNITRANS int]

[MAXTRANS int]

[sTORAGE storage_clause]

[sTORE IN {tablespace_name|DEFAULT]

[sUBPARTITION [subpartition [TABLESPACE tablespace]]]])

 

GLOBAL PARTITION BY RANGE (col_list)

( PARTITION partition VALUES LESS THAN (value_list)

[LOGGING|NOLOGGING]

[TABLESPACE {tablespace|DEFAULT}]

[PCTFREE int]

[PCTUSED int]

[iNITRANS int]

[MAXTRANS int]

[sTORAGE storage_clause] )

 

INDEXTYPE IS indextype [PARALLEL int|NOPARALLEL] [PARAMETERS ('ODCI_Params')]

{This for table index only, not bitmap join Index}index_attribs:

any combination of the following

 

NOSORT|SORT

REVERSE

COMPRESS int

NOCOMPRESS

COMPUTE STATISTICS

[NO]LOGGING

ONLINE

TABLESPACE {tablespace|DEFAULT}

PCTFREE int

PCTUSED int

INITRANS int

MAXTRANS int

STORAGE storage_clause

PARALLEL parallel_clauseIf the PARALLEL clause is used it should be the last option.

 

 

Agora, você irá conforme a sua necessidade e negócio.

 

Abraços,

http://forum.imasters.com.br/public/style_emoticons/default/grin.gif

[dbandre29 0]

Fala Rodrigo beleza sobre a sintaxe ta beleza mas onde e quando devo cada um deles