Explain the impact of indexing strategies on write performance versus read performance in relational and analytical databases. Using the supplied workload and index metadata, write a SQL query that summarizes this tradeoff for active database tables and classifies each table's indexing profile.
table_name, database_type, read_operations, write_operations, read_write_ratio, index_count, avg_write_amplification_pct, best_read_latency_ms, and indexing_profileread_write_ratio descending, then table_name ascending| Column | Type | Description |
|---|---|---|
| table_namePK | VARCHAR(100) | Database table name |
| database_type | VARCHAR(30) | Relational or analytical database classification |
| is_active | BOOLEAN | Whether the table is currently active |
| Column | Type | Description |
|---|---|---|
| strategy_idPK | INT | Index strategy identifier |
| table_name | VARCHAR(100) | Referenced database table |
| index_count | INT | Number of indexes represented by the strategy |
| write_amplification_pct | DECIMAL(6,2) | Estimated additional write work caused by indexing |
| best_read_latency_ms | DECIMAL(8,2) | Best observed read latency in milliseconds |
| Column | Type | Description |
|---|---|---|
| metric_idPK | INT | Workload measurement identifier |
| table_name | VARCHAR(100) | Referenced database table |
| read_operations | BIGINT | Observed read operations |
| write_operations | BIGINT | Observed write operations |