Imagine that for a simple sales report you need to write JOINs on several tables each time - for example, orders, users and products. It's tedious, it's easy to make mistakes in connection conditions and duplicate the same logic in different reports. A View is a named query stored in the database directory: you access it as a table, and the DBMS substitutes the view definition and executes it.