Answer Posted / Ambesh Kumar Bhatt
A Primary Key is a special type of constraint that uniquely identifies each record in a table. An Index is a database object that improves the performance of queries by allowing SQL Server to find and retrieve rows more quickly.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What is the primary use of the model database?
How raid can influence database performance?
What is sql or structured query language?
What is clustered index
What are the different SQL Server Versions you have worked on?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
Equi join and non equi join is possible with sql server?
How do I create a trace in sql server?
Can we do dml on views?
What kind of problems occurs if we do not implement proper locking strategy?
Explain “row_number()” in sql server with an example?
List out the different types of locks available in sql server?
How to remove duplicate rows from table except one?
What are the different types of subquery?
