1. clickbat (reminds patent descriptions ;)); the article itself is about routine query optimization 2. there is no "materialized view" - the view created is a

1. clickbat (reminds patent descriptions ;)); the article itself is about routine query optimization 2. there is no "materialized view" - the view created is a standard one; subquery materialization != materialized views. see wikipedia article (https://en.wikipedia.org/wiki/Materialized_view https://en.wikipedia.org/wiki/Materialized_view) to find what materialized views are