Can anyone say Materialized view and Synonyms PROS and CONS?
Best regards, Kristaps
Asked
Active
Viewed 1,662 times
0
-
possible duplicate of [What are the pros/cons of using a synonym vs. a view?](http://stackoverflow.com/questions/869073/what-are-the-pros-cons-of-using-a-synonym-vs-a-view) – Jørn Schou-Rode Nov 30 '11 at 08:11
1 Answers
1
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.
