Materialized views and synonyms

Can anyone say Materialized view and Synonyms PROS and CO开发者_开发技巧NS?

Best regards, Kristaps

There are a couple of articles out there:

Views, Materialized Views and Synonyms

From SO: What are the pros/cons of using a synonym vs. a view?

It depends on what your need is. The big difference is that the Synonym is simple an alias for the object, which you are not able to filter.

The views allow you to add WHERE clauses and apply column aliases and use expressions for column names. You also have additional security at the View level that you would not have in a Synonym.