Forum Discussion
powerbiexpert22
Impactful Individual
2 days agoReporting Views
what is the deciding factor for creating views in datawarehouse for reporting purpose, how i would know whether i should create view , as far as i know views are created for performance enahancement ...
rajendraongole1
Super User
2 days agoHi powerbiexpert22 - A view is generally not created for performance enhancement. A normal SQL view is primarily an abstraction/reusability/security/semantic layer. In most database engines, the underlying query is expanded into the execution plan, so simply putting a query into a view does not inherently make it faster. A normal view doesn't necessarily mean the database first generates the entire view and then filters it.
Note: Create a view when you need a reusable, governed and stable logical representation of warehouse data - not simply because you expect better performance.
Hope this helps.