Answer Posted / Shiv Prasad Shukla
Update Statistics in Sybase is a database maintenance task that updates the statistics for a specific table or index. These statistics are used by the query optimizer to make informed decisions about which execution plan to use for a given query. Over time, as data in the tables changes, the statistics can become stale and misleading, leading to suboptimal query performance. Updating statistics helps ensure that the query optimizer has up-to-date information when choosing an execution plan.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
