If we declare constraints Unique and Not null on a single
column then it will act as a Primary key, so what is the use
of primary key??
Answer Posted / neha sinha
1) Primary key creates clustered index and unique key
creates non-clustered index. Performance wise clustered
index is fast so we need Primary key.
2)if we need more then one primary key in table than we can
use unique key+NOT NULL becous it behave as Primary key but
we cant define more than one column as primary key. :)
Is This Answer Correct ? | 23 Yes | 1 No |
Post New Answer View All Answers
What does the file extension accdb stand for?
What does pl sql stand for?
What is rtm stands for?
Is oracel sql developer written in java?
Is sqlite free?
Can we create clustered index without primary key?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
How can we make an if statement within a select statement?
Enlist the data types that can be used in pl/sql?
What is the need of merge statement?
What is %s in sql?
How you improve the performance of sql*loader? : aql loader
What is sql*loader?
what are enums used for in mysql? : Sql dba
What is partition in sql query?