Would it be a good idea to create an index on a table that
always contains 10 records? Why or why not?
Answer Posted / laxman
Not a good idea.
Indexes are used for improve select query performance.
indexes will be useful when the data is more and more.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain the microsoft sql server delete command? : SQL Server Architecture
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
What is the difference between for trigger and after trigger?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
What is forward - only cursors / read only cursor?
Define Business Edition in SQL Azure?
What are the difference between “where” and “having” clause in sql server?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
How to declare and use cursor variables?
Tell me when is the update_statistics command used?
Give main differences between "Truncate" and "Delete".
How to change server name in sql server?
How to rebuild master databse?
What is unpivot?