Figure 2: Partial
SET EXPLAIN output for a complex query
QUERY:
------
SELECT fname, lname, company FROM customer
WHERE company MATCHES 'Sport*' AND
customer_num BETWEEN 110 AND 115
ORDER BY lname
Estimated Cost: 1
Estimated # of Rows Returned: 1
Temporary Files Required For: Order By
1) virginia.customer: INDEX PATH
Filters: virginia.customer.company MATCHES 'Sport*'
(1) Index Keys: customer_num (Serial, fragments: ALL)
Lower Index Filter: virginia.customer.customer_num >= 110
Upper Index Filter: virginia.customer.customer_num <= 115