You have used Index to help you accelerate to find what you want, you also know that join is convenient and difficult.
You have personally seen hundreds of columns of the data table, and you want just a drop in the ocean of the results of the information.
Then you have used the view (View)?
In addition to understanding the SQL Join, Group By, in addition to familiar with the statistical functions in the database system, you can also use the view to help you strengthen your workflow, reduce the impact of your complexity, and even provide a buffer space to allow developers to have more room to play.
This program will briefly share
- What is a view
- Patterns and antipatterns of views
- How to improve a view step by step (Notice: The English content is automatically translated and may contain inaccuracies or misinterpretations. Please refer to the original version for the most accurate information.)