As my subject suggests, I would like to know does creating views cause an overhead to DB in terms of space, storage, performance?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
Refer the the Concepts Guide - Overview of Views for this sort of question:
Whether creating a view can have an impact on performance or not isn't answerable. If you don't use it, it won't impact anything. If you use it and it happens that the query the view "represents" has poor performance characteristics, then it will have essentially the same bad impact as running the underlying query directly.
Now materialized views are a completely different concept, and do actually contain data. They can also impact the performance of SQL statements that don't explicitly mention them via query rewriting - but again, what sort of impact that would have isn't answerable without specific details.
(Materialized views are more frequently (but not exclusively) used in data warehousing-type scenarios, whereas plain views are simply all over the place.)