tags:

views:

52

answers:

0
Q: 

Materialized views and synonyms

Hi! Can anyone say Materialized view and Synonyms PROS and CONS?

Best regards, Kristaps

related questions

Incredibly slow Materialized View creation when using string aggregation, any performance suggestions?
Materialized view or CDC?
Oracle refresh materialized view - Compile error
Update materialized view when urderlying tables change
NHibernate and indexed views (materialized views)
How can I tell if a Materialized View in Oracle is being used?
Is it possible to partially refresh a materialized view in Oracle?
Materialized View with column aggregate
Materialized view with Oracle
Help needed for optimizing linq data extraction
Query/Database Optimization: How to optimize this? (and should I use a materialized view?)
CREATE TABLE AS SELECT killing MySQL
What can cause a materialized view in Oracle 10g to stop fast refreshing?
How can a materialized view be created in sqlite?
MySQL not using index with JOIN, WHERE and ORDER
Performance of Remote Materialized views in Oracle
Oracle Materialized Views Vs Replication on the same DB server
How to test materialized view in java
Why does DBMS_MVIEW.REFRESH have an implicit commit?
Oracle materialized view tuning
Does MySQL view always do full table scan?
Does informix have a "materialized view" equivalent or DB-table syncing
oracle materialized view refresh time
Is it possible to have an indexed view in MySQL?
What is the difference between Views and Materialized Views in Oracle?