Clustered vs Non-Clustered Indexes

Problem

A candidate is asked during an interview where the physical rows are stored in a table. Explain the difference between index types. Write a query that outputs answer with the value: "A clustered index stores the actual data rows in the leaf nodes of the index, whereas a non-clustered index stores pointers to the data rows."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution