Forum Discussion
How does views in database improve it's performance. Is quering between views create good performan
Hi, I'm working on an application where I have the following doubt: 1. Does a view improve the performance of DB ?(Was unable to understand even after reading the below reference) 2. In case I...
blackbaron , a view is just a predefined query (like a macro) and has no effect on performance.
You can create an index on a view, but there are several limitations.
Better create index on the base table instead on a view; so that ad-hoc queries can also benefit of the index.
- USE ETL tools put the datas into a table
