Index Type Unique & Non Unique Index Explain

Explain Index & Types Of Index In DBMS, Unique & Non Unique Index In DBMS, What Is Unique & Non Unique Index Explain

Two types of indexes can be created.
Unique index
Non-unique index

Unique Index:
It is created automatically by the oracle server when we define a column in a table to have a primary key or a unique key constraint.
The name of a index is name given to constraint.

Non Unique Index:
It is crated by the user.

Tweet