> CREATE TABLE defg (
  d INT,
  e INT,
  f INT,
  g INT,
  INDEX dd (d),
  INDEX dfg (d, f, g),
  INDEX df (d, f)
);

> explain SELECT d, f, e FROM defg@{NO_INDEX_JOIN} ORDER BY d, f, e LIMIT 10;
                       info
---------------------------------------------------
  distribution: local
  vectorized: true

  • top-k
  │ order: +d,+f,+e
  │ k: 10
  │
  └── • index join
      │ table: defg@defg_pkey
      │
      └── • scan
            missing stats
            table: defg@df
            spans: FULL SCAN (SOFT LIMIT)

  index recommendations: 1
  1. type: index creation
     SQL command: CREATE INDEX ON defg (d, f, e);
(18 rows)