Interested to Buy Any Domain ? << Click Here >> for more details...
How you can find out if an index is useful to the optimizer?
- 1 Answers
- 1005 Views
- I also Faced
- E-Mail Answers
Answer Posted / Vinod Kumar Yadaw
You can check the query plan to determine whether an index is being used or not. If the 'Seek' operator is present in the execution plan, it means the index is being used.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
Can you index views?
What are wait types?
What kind of problems occurs if we do not implement proper locking strategy?
Can sql servers link to other servers like oracle?
How can we solve concurrency problems?
Can we shrink data file in sql server?
What are the different types of subquery?
Where can you add custom error messages to sql server?
Why we use the openxml clause?
What is standby servers? Explain types of standby servers.
What are different types of constraints?
What is the difference between for xml raw and for xml auto?
Can one drop a column from a table?
How to convert character strings into numeric values?
