MySQL :- Secondary Indexes and the Clustering Keys – Day 2

Preface In our last post, we spoke about how one might not need to add the Clustering columns when defining a Secondary Index. At that point, we touched on the fact that just reviewing the Query Plan via "Visual Explain" might not fully reveal whether the Index used is "covering" or whether the Clustered Index is … Continue reading MySQL :- Secondary Indexes and the Clustering Keys – Day 2

MySQL :- Secondary Indexes and the Clustering Keys

Preface RDMS Database tables can either be stored as a Heap or Clustered. When stored as a Heap, data is appended as they come in.  When Clustered, data is sequenced based on the Clustering Columns. Secondary Indexes For Clustered tables, the Clustering data is written as an additional data on each record.  On the other hand … Continue reading MySQL :- Secondary Indexes and the Clustering Keys