Oracle - Is there any effects of not having a primary key on a table ?
- by Sathya
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.