OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » indexes

Thu, 14 February 2002 00:11

krishna
Messages: 141
Registered: October 1998

Senior Member

What are the differences between indexes, unique indexes and non unique indexes?

Thu, 14 February 2002 03:33

Mike
Messages: 417
Registered: September 1998

Senior Member

unique indexes are indexes used for values which are unique and if the value is not unique you are using a non unique index

before asking to much question I recommand you to read some documentation to get a basic knowledge. Have a look at
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76965/toc.htm

Previous Topic:	Select Function
Next Topic:	Re: Explain plan

Goto Forum:

]

Current Time: Sat May 31 22:13:20 CDT 2025