Partitioning vs Clustering | Dataford Interview Questions

Explain the difference between clustering and partitioning.

Use PostgreSQL terminology and distinguish physical row organization from logical table decomposition. Return a concise comparison of the two techniques based on the supplied reference data.

Output

One row for each technique requested, with columns technique, physical_behavior, query_impact, maintenance_behavior, and recommended_when.
Include only Clustering and Partitioning.
Sort alphabetically by technique.

Schema

storage_techniques

Column	Type	Description
technique_idPK	INT	Unique identifier for a storage technique
technique	VARCHAR(40)	Name of the storage technique
category	VARCHAR(40)	Broad category for the technique

storage_characteristics

Column	Type	Description
technique_idPK	INT	References storage_techniques.technique_id
physical_behavior	VARCHAR(255)	How the technique organizes stored data
query_impact	VARCHAR(255)	Typical effect on query execution
maintenance_behavior	VARCHAR(255)	Maintenance required after data changes
recommended_when	VARCHAR(255)	Situation where the technique is appropriate

Your question is Partitioning vs Clustering. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem