Interested to Buy Any Domain ? << Click Here >> for more details...
When would you prefer to have a minimum number of indexes?
- 1 Answers
- 984 Views
- I also Faced
- E-Mail Answers
Answer Posted / Kush Kant Srivastava
You may want to have a minimal number of indexes in the following scenarios:n1. When performance is critical, and frequent data modifications are expected.n2. For tables with fewer rows or small data sizes, where searching can be performed efficiently without indexes.n3. If you suspect that an index might lead to reduced performance due to the way it's designed or used.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a view in sql?
How can we solve concurrency problems?
What are the different SQL Server Versions you have worked on?
What is normalization and what are the advantages of it?
How to rebuild the master database?
How to convert character strings into numeric values?
Why use identity in sql server?
What is clustered index
What are the different types of subquery?
What is temporary table in sql server? Why we use temp table?
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?
List the ways in which dynamic sql can be executed?
What is the difference between for xml raw and for xml auto?
Can sql servers link to other servers like oracle?
How do I create a trace in sql server?
