srinivasa.dinesh

 Profile Answers by srinivasa.dinesh 

• Jan 29th, 2008

 

Unique Index:
If the index is for a primary or unique key then the owner, name, type, and columns cannot be modified. These properties are all derived from the key constraint. Changing the name of the key constraint will automatically change the name of the corresponding index, changing the constraint columns will change the corresponding columns for the index. The owner will always be the same as the owner of the table,

and the type of the index will always be unique.

Simple Index: If the index is created with out any constraint on a table it will be simple index.

Hope this answers your question.

Cheers,
Srini.

sampra

 Profile Answers by sampra 

• Mar 6th, 2012

 

index create on Primary key or unique key is Unique index where as index created on any other element is simple index