Database Reference
In-Depth Information
appropriate table in a query. The best optimizers are already learning to
access the right summary table, although the SELECT statement actually
refers to the fact table. If an optimizer does not have this capability, or if
its hit ratio is not good enough, each end user may be forced to access
one summary table only. Summary tables that an optimizer is aware of
are also known as
automatic summary tables
or materialized views.
Search WWH ::
Custom Search