DBAz,



What is the difference between a Primary Key created on UNIQUE INDEX and a primary key created on a NON UNIQUE INDEX?



What is the impact on Integrity constraint?

What is the impact on Performance?





Regards,

Rajesh Menon



Disclaimer
----------------------------------------------------------------------------------------------
This email is intended only for the named person or entity to which it is addressed and contains valuable business information that is privileged, confidential and/or otherwise protected from disclosure. Dissemination, distribution or copying of this email or the information herein, by anyone other than the intended recipient or an employee or an agent responsible for delivering the message to the intended recipient, is strictly prohibited. All contents are the copyright property of Mudra Communications Pvt. Ltd. (Mudra) or its group Companies or its clients. If you are not the intended recipient, you are nevertheless bound to respect the sender's legal rights. We require that unintended recipients delete the email and destroy all electronic copies in their system, retaining no copies in any media. Information in this message that do not relate to the official business of sender or its group Companies shall be understood to be neither given nor endorsed by the Company. If you have received this e-mail in error, please notify us immediately by email to [Email address protected]

The email has been successfully scanned for presence of virus. It is recommended to scan along with attachment, if any, before launching. We do not accept any liability for any errors, omissions, viruses or computer problems experienced by any recipient as a result of this email.
----------------------------------------------------------------------------------------------


Oracle LazyDBA home page