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
- 5532 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
How do I create an extended event in sql server?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
How can we determine what objects a user-defined function depends upon?
Define cursor locking
Is ssrs support other database except ms sql server?
How to create hyperlink from returned sql query ?
Does partitioning improve performance sql server?
What is the fastest way to permanently delete a 1 million row table named customers?
sql database suspect We have a sql database that is showing as suspect. How can we recover?
What are the disadvantages of using the stored procedures?
Data table as parameter in sql server?
What is the sql server 2000 version number?
What is difference in performance between insert top (n) into table and using top with insert?
What is database replication?
Can you insert NULL in unique column?
