Oracle - Is there any effects of not having a primary key on a table ?
Posted
by Sathya
on Stack Overflow
See other posts from Stack Overflow
or by Sathya
Published on 2009-07-01T11:32:41Z
Indexed on
2010/04/10
8:43 UTC
Read the original article
Hit count: 302
We use sequence numbers for primary keys on the tables. There are some tables where we dont really use the primary key for any querying purpose. But, we have Indexes on other columns. These are non-unique indexes. The queries use these non-primary key columns in the WHERE conditions.
So, I dont really see any benefit of having a primary key on such tables. My experience with SQL 2000 was that, it used to replicate tables which had some primary key. Otherwise it would not.
I am using Oracle 10gR2. I would like to know if there are any such side-effects of having tables that dont have primary key.
© Stack Overflow or respective owner
