-
Remove Primary Key
What happens if we remove primary key from SQL table?
pravesh28
- Mar 9th, 2010
No problem, we use rename operationand we relace the forigen key inti primary key
bikash_tamang
- Jul 10th, 2009
Once the primary key is removed two things will happen:1. The clustered index is also removed which decreases performance and2. The table would then allow duplicate data to be inserted causing data corruption.
-
What is BITMAP index and B-Tree Index in Oracle 10g
.
raja_wipro
- Dec 2nd, 2008
In Oracle 10G we do not have Bitmap Index . Bitmap index is available only in Oracle9i Enterprise Edition
