Which of the following is a multi-query optimization technique
(a) Shared scan optimization
(b) Parametric query optimization
(c) Index optimization
(d) All of the mentioned
The question was asked during an interview.
I want to ask this question from Materialized Views and Advanced Topics in Query Optimization topic in chapter Query Processing and Optimization of RDBMS