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
- 5480 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
List out some of the requirements to set up a sql server failover cluster?
What is after dml trigger?
How to provide column names in insert statements in ms sql server?
How you can change the database name in SQL SERVER?
What is deploy, process and build? : sql server analysis services, ssas
Explain the disadvantages/limitation of the cursor?
What are the types of indexes?
Why we use trigger in sql server with example?
What is data mart? : sql server analysis services, ssas
Why are sql functions used?
What is the difference between executequery () and executeupdate ()?
Explain about thread and memory management process of SQL?
What are the kinds of subquery?
Is natural join and equi join same?
Define inner join in sql server joins?
