Home » SQL & PL/SQL » SQL & PL/SQL » indexes
indexes [message #18780] Thu, 14 February 2002 00:11 Go to next message
krishna
Messages: 141
Registered: October 1998
Senior Member
What are the differences between indexes, unique indexes and non unique indexes?
Re: indexes [message #18787 is a reply to message #18780] Thu, 14 February 2002 03:33 Go to previous message
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: Fri Mar 29 03:16:52 CDT 2024