Can we create index on primary key?



Can we create index on primary key?..

Answer / Niraj Kumar

Yes, you can create an index on a primary key in SQL. Since primary keys are already unique and typically used for faster data retrieval, adding an index on a primary key can further improve the performance of queries involving that column.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is the purpose of a secondary key?

1 Answers  


how would concatenate strings in mysql? : Sql dba

1 Answers  


What is difference between rank () row_number () and dense_rank () in sql?

1 Answers  


What does bitemporal mean?

1 Answers  


Can you sum a count in sql?

1 Answers  


Compare SQL and PL/SQL.

3 Answers  


What are the modes of parameters that can be passed to a procedure ?

3 Answers  


What is rank () in sql?

1 Answers  


How do you drop a trigger?

1 Answers  


What is microsoft t sql?

1 Answers  


How many commands are in sql?

1 Answers  


how can we optimize or increase the speed of a mysql select query? : Sql dba

1 Answers  


Categories