CSG interview question

How Indexing works internally in SQL.