Interested to Buy Any Domain ? << Click Here >> for more details...
Would it be a good idea to create an index on a table that
always contains 10 records? Why or why not?
- 3 Answers
- 5394 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between varchar and varchar(max) datatypes?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
What is the difference between upgrade and migration in sql server?
Explain Normalization and DE normalization
What is normalization and denormalization in sql server?
What is the contrast amongst drop and truncate?
Explain the categories of stored procedure?
how you can list all the tables in a database?
What are the requirements for sql server 2016?
What are the benefits and tasks of object explorer? : sql server management studio
How to create a dynamic cursor with the dynamic option?
Tell me the phases a transaction has to undergo?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
How to see existing views in ms sql server?
How to concatenate two strings in SQL Server.
