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
- 5626 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 you tell me some of the common replication dmv's and their use? : sql server replication
What is the correct order of the logical query processing phases?
How to find the version of sql server? : sql server database administration
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
Why the trigger fires multiple times in single login?
How to create indexed view?
Explain the categories of stored procedure?
When would you use the stored procedures or functions?
What are the options which must be set to allow the usage of optimistic models?
When we should use and scope of @@identity?
What is the partitioning method?
Explain steps of normalization?
Write the syntax for stuff function in an sql server?
Detail about the hardware which is supported by SQL server?
How global temporary tables are represented and its scope?
