GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

ANALYZE TABLE

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • ANALYZE TABLE

    Hi,

    Does anybody know if an ANALYZE TABLE will optimize queries that do not join tables?

    DG

  • #2
    Yes, recreating the stats for a table can result in new query plans for a table that has an index. For example, a query always has a choice to an index, and if more than one index , which index, or do a table scan and ignore all the indexs.

    Comment

    Working...
    X