By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
A view is just a stored query and has no physical part. Once a view is instantiated, performance can be quite good, until it is aged out of the cache. A materialized view has a physical table associated with it; it doesn't have to resolve the query each time it is queried. Depending on how large a result set and how complex the query, a materialized view should perform better.
Dig Deeper on Oracle database design and architecture
Related Q&A from Mike Ault
I am trying to remove carriage returns at the end of clob fields in SQL*Plus. This just nulls out the field in the table. What do I need to change to...continue reading
How to find the definition or structure of a dropped table? I know the table's name but I don't know the columns and datatypes. It no longer exists.continue reading
I'm having a problem with dynamic SQL, specifically getting my incoming parameter into the SQL statement. I am using Oracle 9i and this procedure ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.