An Index for a Calculated Value

Medium

Description

Finance often looks for order lines by their value, quantity * unit_price, with this query:

Code
SELECT * FROM order_items WHERE quantity * unit_price = 24999;

Create an index named idx_line_value that this query can use. Then show the query's plan without costs, with exactly this statement:

Code
EXPLAIN (COSTS OFF) SELECT * FROM order_items WHERE quantity * unit_price = 24999;

Medium

Finance often looks for order lines by their value, quantity * unit_price, with this query:

Code
SELECT * FROM order_items WHERE quantity * unit_price = 24999;

Create an index named idx_line_value that this query can use. Then show the query's plan without costs, with exactly this statement:

Code
EXPLAIN (COSTS OFF) SELECT * FROM order_items WHERE quantity * unit_price = 24999;

Medium

Finance often looks for order lines by their value, quantity * unit_price, with this query:

Code
SELECT * FROM order_items WHERE quantity * unit_price = 24999;

Create an index named idx_line_value that this query can use. Then show the query's plan without costs, with exactly this statement:

Code
EXPLAIN (COSTS OFF) SELECT * FROM order_items WHERE quantity * unit_price = 24999;

Medium

Finance often looks for order lines by their value, quantity * unit_price, with this query:

Code
SELECT * FROM order_items WHERE quantity * unit_price = 24999;

Create an index named idx_line_value that this query can use. Then show the query's plan without costs, with exactly this statement:

Code
EXPLAIN (COSTS OFF) SELECT * FROM order_items WHERE quantity * unit_price = 24999;