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
What are views in ms sql server?
What is sql view?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
What is subquery explain with example?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
Explain comment on transactions?
Can primary key be a foreign key?
What is temporal data type?
State a few properties of relational databases?
How to create database with physical files specified in ms sql server?
What is the difference between char and varchar2 datatype in sql?
How to convert numeric expression data types by assignment operations?
How global temporary tables are represented and its scope?
What are the differences between web role and worker role?
whats the maximum size of view state??