Question

when would you use this view?​

Answer 1

Answer:

hello 2021..................

Answer 2

Answer:

Views are a logical virtual table created by “select query” but the result is not stored anywhere in the disk and every time we need to fire the query when we need data, so always we get updated or latest data from original tables.

The performance of the view depends on our select query. If we want to improve the performance of view we should avoid using join statements in our query or if we need multiple joins between table always try to use the index-based column for joining as we know index-based columns are faster than a non-index based column.

View also allows storing the definition of the query in the database itself.