Re: Unique and non unique index

> We can enforce primary key constraint by using both unique
> and non-unique index. I want to know when to use unique index and when
> non unique.

You've got it backwards.

Use -constraints- for business rules enforcements:

- primary key constraints
- unique constraints
- check constraints
- referential constraints

and use indices for performance reasons.

-- 
Martijn Tonies
Database Workbench - development tool for Oracle, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com