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 |
How to use the inserted and deleted pseudo tables?
What are the types of backup and tell me the difference between full and differential backup?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
How do you make a trace?
What is query optimizer in sql server?
Which index created when Create Index on table(col), Why
Do you know what are the restrictions that views have to follow?
About types of indexes in SQL server ?
What is merge replication?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
0 Answers HPCL, Hughes Systique Corporation,
What is xml datatype?
How is a full-text index updated?