| Materialized Views vs Tables? [message #221439] |
Mon, 26 February 2007 14:44  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
