First page Back Continue Last page Overview Graphics
Covering Indexes: Poor Mans Clustered Indexes
Index that includes all columns in the SELECT.
SELECT can use index (only) for queries, similar to InnoDB primary key.
Inserts and deletes are penalised.
Possible alternative if clustered index cannot be used (Legacy application, MyISAM/Maria, ...).
Case story: CBB Mobilsvar.