tag:blogger.com,1999:blog-2634839917427649118.post3687709024074957486..comments2024-03-28T15:06:58.848+05:30Comments on IBM MAINFRAME FORUM: What is the difference between Primary key and Unique index in DB2Anonymoushttp://www.blogger.com/profile/14326227685841827094noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-2634839917427649118.post-91386350240573190142014-06-17T22:58:34.207+05:302014-06-17T22:58:34.207+05:30Hi Sreeni.. thanks!..
Refer to this for better un...Hi Sreeni.. thanks!.. <br />Refer to this for better understanding:<br />http://www-01.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.intro/src/tpc/db2z_uniqueindexes.dita<br /><br />If a unique index does not already exist on the columns of the primary key,<br />then DB2 will create such an index automatically when a PK is defined.<br /><br />It is often desirable to first create the unique index yourself, and then<br />create the PK after that, because if DB2 creates the index automatically for<br />you it cannot be altered for various attributes such as percent free,<br />cluster, allow reverse scans, etc.Anonymoushttps://www.blogger.com/profile/14326227685841827094noreply@blogger.comtag:blogger.com,1999:blog-2634839917427649118.post-32731236845258483792014-06-17T18:14:01.776+05:302014-06-17T18:14:01.776+05:30Nice info Deb.I didn't know that Unique index ...Nice info Deb.I didn't know that Unique index is a madatory thing if there is a primary key!!<br /><br />Sreenivas,<br />www.mainframeinterview.comAnonymoushttps://www.blogger.com/profile/00583703661461219009noreply@blogger.com