How does views in database improve it's performance. Is quering between views create good performan

Question

Hi,&nbsp;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&nbsp; even after reading the below reference)2. In case I create 2 views and run a join query between them, will it affect the performance of the DB ?3. I'm using Azure SQL DB for this project&nbsp;Reference :&nbsp;https://docs.microsoft.com/en-us/sql/relational-databases/views/views?view=sql-server-ver15https://docs.microsoft.com/en-us/sql/relational-databases/views/create-indexed-views?view=sql-server-ver15&nbsp;https://docs.microsoft.com/en-us/sql/relational-databases/views/create-views?view=sql-server-ver15&nbsp;&nbsp;&nbsp;Any help on this is greatly appreciated!!&nbsp;&nbsp;Regads,black baron&nbsp;PS: If this post has helped you, please vote for it.

olafhelper · Answer

blackbaron&nbsp;, 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.

blackbaron · Answer

Thanks olafhelper 🙂This answer gave me a direction. Hoping to see some other viewpoints too

lijetcart · Answer

USE ETL tools put the datas into a table

Forum Discussion

How does views in database improve it's performance. Is quering between views create good performan

Share

Resources