CSG Interview Question

How Indexing works internally in SQL.