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
- 5523 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
Can we perform backup restore operation on tempdb?
What are the different types of collation sensitivity?
How to find Duplicate Records In table?
what is denormalization and when would you go for it? : Sql server database administration
How do you check sql server is up and running?
What is the impact on other user sessions when creating indexes?
how to take backup bcp out for a column in table in sql server?
How to find the login name linked to a given user name?
What is hot add cpu in sql server 2008?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
Is mysql the same as sql server?
Can we use trigger new in before insert?
What is scrollable cursor?
What is the beast way to write CTE in SQL Server ?
What are the advantages of paper records?
