What are indexes, views? (DBMS)

Question

Accepted Answer

Indexes are data structures that improve the speed of data retrieval operations in a database. Views are virtual tables created from queries.

Indexes are used to quickly locate data in a database by creating a sorted structure that allows for efficient searching.
Views are virtual tables that are created by executing a query and storing the result set as a named object.
Indexes can be created on one or more columns of a table to improve the performance of SELECT, UPDATE, and DELETE operations.
Views provide a way to simplify complex queries by creating a virtual table that represents a subset of data from one or more tables.
Indexes can be clustered or non-clustered, with the former physically ordering the data on disk while the latter creates a separate structure.
Views can be used to restrict access to certain columns or rows of a table, providing an additional layer of security.
Indexes are typically used on columns that are frequently used in WHERE clauses or JOIN operations.
Views can be used to combine data from multiple tables into a single virtual table, making it easier to query and analyze the data.

Top UnitedHealth Software Engineer interview questions & answers