I submitted an abstract for a presentation at the Rocky Mountain OUG Training Days 2007, on the subject of materialized views, summaries, fast refresh and whatnot. Obviously a lot of the substance will come from the material I’ve been posting here for the past year-and-a-bit, emphasising conceptual understanding, analysing the internals of the refresh process, a caveat here and there, the ongoing search for optimisation techniques, and with other material to tie it together as a coherent topic.
Since this is aimed at all levels of experience, from “what is a materialized view” through to “Ah, but in the case of partitioning of a HOLAP-based MV …” what issues would you like to see covered in the talk?
Here is what I have so far, in no particular order …
- When and what to summarise.
- Components of a materialized view (table, metadata etc).
- Query rewrite.
- Complete and fast refresh.
- Fast refresh following conventional path, direct path, and partition DDL operations.
- Propagating changes to the MV data.
- Performance issues.
- Alternatives to MV use and tuning manual refresh of summaries.
- Caveats (32-column limitation on GROUP BY, ORA-12034, PCT and prebuilt tables etc)
A lot of ground to cover, but I’ve optimistically applied for a 90 minute slot — I think I could manage double that at a pinch!
What would you emphasise out of that, and what would you add?