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
- 5388 Views
- I also Faced
- E-Mail Answers
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
How to provide login information for a new odbc dsn?
what are different types of raid configurations? : Sql server database administration
can we have a nested transaction? : Sql server database administration
what does the automatic recovery do? : Sql server administration
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What is user defined stored procedures?
What stored by the tempdb ? : sql server database administration
can an automatic recovery be initiated by a user? : Sql server administration
Explain left outer join and right outer join?
Can we linked SharePoint to a SQL database?
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
What is the data tier application?
Find nth lowest salary or get nth lowest salary?
What are commonly used mssql functions in php?
What is an expensive query?
