Oracle PL/SQL: INDEXES: Unique indexes - Using constraints is preferred to using triggers, rules, and defaults. A constraint enforces the int

Quick Search:

Oracle PL/SQL: INDEXES: Unique indexes

Jump to:

Category: >> Oracle PL/SQL >> INDEXES: Unique indexes

<< last

next >>

Snippet Name: INDEXES: Unique indexes

Description: Using constraints is preferred to using triggers, rules, and defaults. A constraint enforces the integrity of a database. It defines rules regarding the values allowed in columns of a table. It is the standard mechanism for enforcing integrity.

Also see:
» INDEXES: View table indexes
» INDEXES: Analyze Index
» INDEXES: Block Dump
» INDEXES: Rebuild Reverse
» INDEXES:
» INDEXES: ENABLE (function-based index)
» INDEXES: DISABLE (function-based index)
» INDEXES: Alter Index Parallel
» INDEXES: Alter Index Deallocate Unused
» INDEXES: Alter Index Allocate Extent
» INDEXES: Virtual / NoSegment
» INDEXES: Reverse Key Indexes
» INDEXES: Bitmap Join Indexes
» INDEXES: Bitmap Indexes
» INDEXES: Parallel Index
» INDEXES: Compute Statistics
» INDEXES: SORT and NOSORT
» INDEXES: Function-Based Index
» INDEXES: DROP index
» INDEXES: Alter index
» INDEXES: Single Column Non-unique
» INDEXES: Index Usage Notes
» Compressed Indexes
» Create INDEX

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 10th, 2009

CREATE UNIQUE INDEX <index_name>
ON <table_name> (<column_name>)
PCTFREE <integer>
TABLESPACE <tablespace_name>;
 
-- for example: 
CREATE UNIQUE  INDEX uidx_sales_region_id
ON index_sales(city_id)
PCTFREE 0
TABLESPACE sales_us;