Would it be a good idea to create an index on a table that
always contains 10 records? Why or why not?
Answers were Sorted based on User's Feedback
Answer / bharathi
No it is not a good idea. Indexes are very expensive to
maintain. Indexes are created mainly to improve performace.
If there are only 10 rows in a table, creating index would
not make any difference in the performace.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / subhash
No it's not a good idea.
Table scan would be fine for smaller tables with less records. Moreover indexes need disk space. It's not necessary to create an index and waste the disk space.
| Is This Answer Correct ? | 1 Yes | 0 No |
What are explicit and implicit transactions?
What are the different types of backup avaible in SQL SErver
List out the difference between union and union all in sql server?
Can we call SP inside a query?
5 Answers CA, CarrizalSoft Technologies, Wipro,
What is lock escalation and what is its purpose?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
What is change data capture (cdc) in sql server 2008?
How do we rollback the table data in SQL Server
hi... this is charan.I persued btech in 2010 looking for a job on database/back-end as freehser. can any seggest me which course or back-end tool i have to learn
Can you explain what are commit and rollback in sql?
How to find tables without indexes?
Name three version of sql server 2000 and also their differences?
Oracle (3259)
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)