Question: what are index in sql?
Answer: An index is an on-disk structure associated with a table or view that speeds retrieval of rows from the table or view. ... These keys are stored in a structure (B-tree) that enables SQL Server to find the row or rows associated with the key values quickly and efficiently.