Last week, I heard a new (to me) term: materialized view. (I'm working in an Oracle shop right now; don't judge me!) Having worked in mostly SQL Server environments, I had never heard of materialized views before. Now I'm spending some time trying to learn about them.
Can anyone recommend any learning resources about them, including (and especially) examples of how to use them?