Would it be a good idea to create an index on a table that
always contains 10 records? Why or why not?
- 3 Answers
- 4420 Views
- I also Faced
- E-Mail Answers
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 |
List down some advantages of sql stored procedure?
What is difference between drop truncate and delete?
What is the difference between a local and a global variable?
Why we need a group by clause?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
How do I debug a stored procedure in sql server?
Explain Different types of Projects?
How To delete duplicate record from a particular table?
what is denormalization and when would you go for it? : Sql server database administration
How to swap the data of two columns in a table. both the columns containing varchar values.
What are the components of dbms?
If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
