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
Rustican
Messages: 51
Registered: July 2006
Member
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
gintsp
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
http://www.gplivna.eu
Previous Topic: How complex is Oracle 10g Server Administration
Next Topic: oracel startup problem
Goto Forum:
  


Current Time: Tue Dec 06 02:39:33 CST 2016

Total time taken to generate the page: 0.10838 seconds