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
- 5522 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to turn off warning messages during php execution?
What is subquery explain with example?
What are page splits? : SQL Server Architecture
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
Explain important index characteristics?
What is a dbms wizard?
What is data mart? : sql server analysis services, ssas
What is bit data type?
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
How to create a user to access a database in ms sql server using "create user" statements?
How to delete an existing database user?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What happens if the update subquery returns multiple rows in ms sql server?
What is analysis service repository?
What is set nocount on and what is set nocount off?
