bd40bc7c7a PARAMETERS In the PARAMETERS clause, specify the parameter string that is passed uninterpreted to the appropriate ODCI indextype routine. Purpose. In both cases, you can specify up to 32 columns as partitioning key columns. Examples . Using a Function-based Index to Define Conditional Uniqueness: Example The following statement creates a unique function-based index on the oe.orders table that prevents a customer from taking advantage of promotion ID 2 ("blowout sale") more than once:. See Also: loggingclause for a full description of this clause Oracle Database Concepts and Oracle Data Warehousing Guide for more information about logging and parallel DML "Creating an Index in NOLOGGING Mode: Example" . Description of the illustration individualhashpartitions.gif. See Also: Oracle Data Cartridge Developer's Guide for information on the Oracle Data Cartridge Interface (ODCI) routines. Description of the illustration segmentattributesclause.gif. Notes on Function-based IndexesThe following notes apply to function-based indexes:.
Oracle Database compresses only nonpartitioned indexes that are nonunique or unique indexes of at least two columns. The only property you can specify for hash partitions is tablespace storage. Creating a Cluster Index: ExampleTo create an index for the personnel cluster, which was created in "Creating a Cluster: Example", issue the following statement:. The logging attribute of the index is independent of that of its base table. For an index key made up of dimension table columns, it stores the fact table rowids corresponding to that key. If you do not qualify table with schema , then Oracle Database assumes the table is contained in your own schema. The following restrictions apply to indexes on temporary tables: The only part of indexproperties you can specify is indexattributes .