We konden deze vermelding niet vinden. Er worden benaderende resultaten weergegeven. Controleer je spelling of stel voor deze term aan het woordenboek toe te voegen.
The recommendations that this advisor makes include possible indexes, materialized views, or materialized view logs that can improve your query performance for the given workload.
You are encouraged to analyze the defining queries of your planned materialized views and identify which filter columns will need to be created in your materialized view logs. If you try to create or refresh a materialized view that requires a filter column before creating the materialized view log containing the filter column, your materialized view creation or refresh may fail.
This topic describes how to use deployment templates and create materialized view logs. In addition, this topic describes how to create, manage, package, and instantiate a deployment template.
Typically, it is important to refresh as soon as possible. The longer the duration between packaging the template and actual instantiation, the greater the amount of changes being stored in the materialized view logs for the materialized views in your deployment template.
A master table's materialized view log keeps track of fast refresh data for all corresponding simple materialized views. When a server performs a fast refresh for a simple materialized view, it uses the data in its master table's materialized view log to refresh the materialized view very efficiently. The Replication Management tool has many features that help you create and manage materialized view logs.
A SQL Access Advisor recommendation can range from a simple suggestion to a complex solution that requires partitioning a set of existing base tables and implementing a set of database objects such as indexes, materialized views, and materialized view logs. You can select the recommendations for implementation and schedule when the job should be executed.
The Master Site object lets you manage the master groups at the replication site, and lets you manage sites that are master sites of materialized view sites. Specifically, this object lets you create, manage, and package deployment templates, and lets you create and manage materialized view logs. This object contains the following folders
Evaluates the master tables for the constraints needed to get the maximum use from the materialized views, particularly for query rewrite. The Advisor looks for NOT NULL constraints, primary key constraints, foreign key constraints, and materialized view logs on the master fact tables. It generates a script that you can save to a file and run at your convenience to apply these changes. The Advisor is available only after the cube has been enabled as a materialized view.
Er worden alleen voorbeelden gegeven om u te helpen het woord of de woordcombinatie waarop u hebt gezocht, te vertalen. Deze worden niet door ons geselecteerd of gevalideerd en kunnen ongepaste taal bevatten. Wij vragen u melding te maken van voorbeelden die dienen te worden aangepast of verwijderd. Vertalingen met grof of informeel taalgebruik worden meestal rood of oranje gemarkeerd.