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
- 5389 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 do I view views in sql server?
What is the recursive stored procedure in sql server?
How to write a query with a full outer join in ms sql server?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
Explain what is it unwise to create wide clustered index keys?
What is 'write-ahead log' in sql server 2000 ?
How to drop existing indexes in ms sql server?
How to call stored procedure using http soap?
What is the difference between inner join and equi join?
Does index slows down insert statements?
What are basics of policy management?
What are the extra roles available in msdb? : sql server security
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
What will happen if a column containing char type data is changed to the nchar data type?
How to create function without parameter in sql server?
