Would it be a good idea to create an index on a table that
always contains 10 records? Why or why not?
Answer Posted / bharathi
No it is not a good idea. Indexes are very expensive to
maintain. Indexes are created mainly to improve performace.
If there are only 10 rows in a table, creating index would
not make any difference in the performace.
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is the name of the system variable that returns the number of rows affected by a SQL statement?
Can two tables have the same primary key?
Define union, union all, minus, intersect?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
Define full outer join in sql server joins?
What is model database? : SQL Server Architecture
How many databases Microsoft SQL server provides?
How does recursive cte works in sql server?
tell me the disaster recovery plan
What are the recovery models in sql server 2000?
What is the difference between char and varchar2 datatype in sql?
How to make a column nullable?
What are functions in the sql server?
How to find Duplicate Records In table?
Write a sql query to get zero records from a table having n number of records?