Materialize/doc/user/data/index_usage_key_quantity_price.yml

# CREATE INDEX idx_orders_view_qty on orders_view (quantity);
queries:
  - query: |
      ```mzsql
      SELECT * FROM orders_view;
      ```
    index_usage: Index scan.

  - query: |
      ```mzsql
      SELECT * FROM orders_view WHERE quantity = 10;
      ```
    index_usage: |
      Index scan. Query does not include equality conditions on **all** indexed
      fields.

  - query: |
      ```mzsql
      SELECT * FROM orders_view WHERE quantity = 10 AND price = 2.50;
      ```
    index_usage: Point lookup.

  - query: |
      ```mzsql
      SELECT * FROM orders_view WHERE quantity = 10 OR price = 2.50;
      ```
    index_usage: |
      Index scan. Query uses `OR` to combine conditions on **different** fields.

  - query: |
      ```mzsql
      SELECT * FROM orders_view
      WHERE quantity = 10 AND (price = 2.50 OR price = 3.00);
      ```
    index_usage: |
      Point lookup. Query uses `OR` to combine conditions on **same** field and `AND` to combine conditions on **different** fields.

  - query: |
      ```mzsql
      SELECT * FROM orders_view
      WHERE quantity = 10 AND price = 2.50 AND item = 'cupcake';
      ```
    index_usage: |
      Point lookup on the index keys `quantity` and `price`, then filter on
      `item`.

  - query: |
      ```mzsql
      SELECT * FROM orders_view
      WHERE quantity = 10 AND price = 2.50 OR item = 'cupcake';
      ```
    index_usage: |
      Index scan. Query uses `OR` to combine conditions on **different** fields.