Clustered vs Non-clustered

Databasesdb

The Question

What is the difference between clustered and non-clustered indexes?

What a Strong Answer Covers

• Physical ordering
• one per table
• pointer-based non-clustered.

Related Questions

• ACID
• Indexes
• Isolation Levels
• Normalization
• PostgreSQL Internals — MVCC, WAL, VACUUM