Answer Posted / Drishti Bharti
"The UPDATE STATISTICS command in SQL Server is used to rebuild or create statistics for an indexed column. Statistics help the Query Optimizer make better decisions regarding query execution plans, improving performance when running queries involving WHERE, JOIN, GROUP BY, and ORDER BY clauses.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are different types of constraints?
What are the kinds of subquery?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Does view occupy space?
what is the difference between openrowset and openquery?
How to rebuild the master database?
What is an indexed view?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
Why should you use or avoid select * statements?
Equi join and non equi join is possible with sql server?
What is subquery? Explain the properties of a subquery?
List the ways in which dynamic sql can be executed?
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
What is a view in sql?
