Over the years, I have debated the proper use of views, and, almost without exception, developers are loathe to use them - especially Java developers. The number one reason for their argument is performance.

Two part question (Please forget about materialized views for now):

1) Is there a(any) valid reason(s) for NOT using views? In other words, is there any advantage to using queries over views? Whether it is because of performance, or whatever. This goes for updateable views as well as just select views.

2) Do these reasons for NOT using views outweigh the consistent extraction of data? For example, preventing a poorly performing query, or an invalid query (e.g., a query being written that fails to filter on most current effective date)?

The reason for ignoring materialized views is that I concede that there is overhead with complicated queries, whether it is in the form of a view, or a query, and creating materialized views is the only realistic response to this problem. Unfortunately, materialized views are a hard sale too since everyone in the reporting world wants a dimensional model -- which is another debate (e.g. Kimball vs Inmon).