Question: what are views and indexes?
Answer: SQL technique: views and indexes. A view is simply any SELECT query that has been given a name and saved in the database. For this reason, a view is sometimes called a named query or a stored query. ... This not only avoids name conflicts with base tables, it helps in reading any query that uses a view.