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
- 5630 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
What are logical database components? : SQL Server Architecture
Can we hide the definition of a stored procedure from a use?
How do I start and stop sql server?
What is sql view?
What is row-level compre?
how to create a scrollable cursor with the scroll option? : Sql server database administration
What have included columns when we talk about sql server indexing?
How to use wildcard characters in like operations in ms sql server?
Can multiple columns be used in sql group by clause in ms sql server?
What is stored procedures?
How can you check the level of fragmentation on a table?
Do you know data definition language, data control language and data manipulation language?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What is truncate table?
Explain the commands in sql server?
