Forum Discussion
Reporting Views
- 26 days ago
Hi 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.
Hi 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.