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