In Cloud Spanner, what is the purpose of interleaving tables?

Question

Google Cloud (GCP) — Hard

In Cloud Spanner, what is the purpose of interleaving tables?

Accepted Answer

Interleaving tables in Cloud Spanner enables efficient data retrieval by storing related data together. This co-location reduces I/O operations, making join operations faster. The correct answer, B, achieves this by storing child table rows with parent rows. Options A, C, and D are incorrect as they do not directly address the purpose of interleaving.