Does view improve query performance

AnswerBot
9mo

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
author
9mo
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...
Lionbridge Technologies Senior Database Developer Interview Questions
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+

Reviews

4 L+

Interviews

4 Cr+

Salaries

1 Cr+

Users/Month

Contribute to help millions
Get AmbitionBox app

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter