Examples with "materialized view defined" and their translation in Japans
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.
A materialized view log is a schema object that records changes to a master table's data so that a materialized view defined on the master table can be refreshed incrementally. Each materialized view log is associated with a single master table. The materialized view log resides in the same database and schema as its master table.
In previous releases, a table could not be redefined if it had a log or materialized view defined. But with this release, you can now clone the materialized view log onto the interim just like triggers, indexes, and other similar dependent objects. At the end of the redefinition, ROWID logs are invalidated. Initially, all dependent materialized views must do a complete refresh.
Materialized views are schema objects that can be used to summarize, compute, replicate, and distribute data. A materialized view can be partitioned. You can define a materialized view on a partitioned table and one or more indexes on the materialized view. A materialized view log is a schema object that records changes to a master table's data so that a materialized view defined on the master table can be refreshed incrementally. Each materialized view log is associated with a single master table. The materialized view log resides in the same database and schema as its master table.
A materialized view provides access to table data by storing query results in a separate schema object. Unlike an ordinary view, which does not take up storage space or contain data, a materialized view contains the rows from a query of one or more base tables or views. A materialized view log is a schema object that records changes to a master table's data, so that a materialized view defined on the master table can be refreshed incrementally. SQL Access Advisor recommends how to optimize materialized views so that they can be rapidly refreshed and make use of the query rewrite learn more about materialized views, see Oracle Database Concepts.
When a base table changes, all materialized views defined on the table are updated by a background service that uses compute resources provided by Snowflake.
Do not specify "Include New Values" if you want to disable the recording of new values in the log. This is the default. You can avoid the overhead of recording new values. However, disable "Include New Values" if you have a fast-refreshable single-table materialized aggregate view defined on this table.
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.