Does a view improve query performance?

AnswerBot
1y
Views can improve query performance by simplifying complex queries and reducing the need for redundant code.
Views can store complex queries and calculations, allowing for easier access and reuse of da...read more
Anonymous
1y
No, view just simply query logic . Every time query on view is called underlying query is being executed. Apart from this in case of view index on table is not used
Help your peers!
Add answer anonymously...
Interview Questions Asked to Senior Database Developer at Other Companies
Top Skill-Based Questions for Lionbridge Technologies Senior Database Developer
SQL Interview Questions and Answers
250 Questions
SSIS Interview Questions and Answers
20 Questions
Stay ahead in your career. Get AmbitionBox app


Trusted by over 1.5 Crore job seekers to find their right fit company
80 L+
Reviews
10L+
Interviews
4 Cr+
Salaries
1.5 Cr+
Users
Contribute to help millions
AmbitionBox Awards
Get AmbitionBox app

