|< < 26 > >|

Combining operators

Covering index optimization

  • This is the covering index optimization.

  • The index row has all the rows of the table that are needed later.

  • So the table row retrieval can be skipped.

  • This is a huge optimization, avoiding one random access per index row.

|< < 26 > >|