•  

Announcement

Announcement Module
Collapse
No announcement yet.

ANALYZE TABLE

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

  • ANALYZE TABLE

    #1
    Hi,

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

    DG
    Tags: None

  • #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