Current location - Loan Platform Complete Network - Big data management - Why use queries and views in a database? What's the difference between them?
Why use queries and views in a database? What's the difference between them?
The results generated by the query can only be viewed and cannot be changed.

The result of view generation can be seen, changed and directly reflected in the table of image database.

The query process can be saved as a separate file under windows, while the view is saved in the database, not a separate file.

There seems to be no custom variable in the query, it must be defined by the referenced form. On the other hand, views can customize variables.