Hi,
Does anybody know if an ANALYZE TABLE will optimize queries that do not join tables?
DG
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.