Home » RDBMS Server » Server Administration » Materialized Views vs Tables?
Materialized Views vs Tables? [message #221439] Mon, 26 February 2007 14:44 Go to next message
Messages: 51
Registered: July 2006
Does anyone know if there is a difference in the performance between querying off a indexed table or a materialized view that's created from the table?

What about querying off joined tables and off joined materialized views?
Re: Materialized Views vs Tables? [message #221481 is a reply to message #221439] Tue, 27 February 2007 02:27 Go to previous message
Messages: 118
Registered: February 2007
Senior Member
MVs are stored as usual tables so assuming they have identical structure querying them should be the same. It is not quite clear what you mean by "indexed table"? Table with defined appropriate indexes or Index organized table (a special physical structure of the tables)?
In both cases however MVs can be used in the same way i.e. you can create indexes on MVs and you can create MV as index organized table.
Also at least for me it is not clear what you mean by "off join".

A few big benefits of MVs over simple create table as select (CTAS) are that MVs can be easily automatically updated on periodic or transaction basis and also query rewrite that (assuming you have fullfilled necessary prerequisites) happens automatically.

Gints Plivna
Previous Topic: cronjob
Next Topic: Oracle OS Question: SolarisX86 or RH Linux?
Goto Forum:

Current Time: Sun Aug 20 21:52:40 CDT 2017

Total time taken to generate the page: 0.05084 seconds