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 |
What is the purpose of a secondary key?
how would concatenate strings in mysql? : Sql dba
What is difference between rank () row_number () and dense_rank () in sql?
What does bitemporal mean?
Can you sum a count in sql?
Compare SQL and PL/SQL.
What are the modes of parameters that can be passed to a procedure ?
What is rank () in sql?
How do you drop a trigger?
What is microsoft t sql?
How many commands are in sql?
how can we optimize or increase the speed of a mysql select query? : Sql dba
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)