Does the Query Optimizer have the right to create Temporary (Materialized) Views which can enhance performance? Sorry if this question seem very trivial.

Or in other words, does the query optimizer consider plans which involve creating a temporary table, storing the object on disk and then using it for query execution.

  • Are you talking about in general? Or a specific product? – Anthony Genovese Dec 16 '19 at 15:32
  • You need to specify which DBMS you have in mind – Lennart Dec 16 '19 at 19:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.