Can MQTs use views as underlying objects?

[BD]

Hi there.

I'm attempting to implement MQTs to improve performance on some nasty
SQL.

In the Oracle world, if I recall, materialized views must use tables
as underlying objects - ie., they cannot be based on views.

Does the same hold in db2 (8.2 LUW, 8 z/OS)?

I'm looking in SQL reference 2 about the syntax for the fullselect,
and although I suspect by the wording that I am correct, I'm not
finding a specific statement such that an underlying object referenced
by the fullselect cannot be a view.

I'll keep looking...

Tx,

BD.

[BD]

Re: Can MQTs use views as underlying objects?

On Apr 10, 3:15 pm, BD <robert.d...@gm ail.comwrote:

Hi there.
>
I'm attempting to implement MQTs to improve performance on some nasty
SQL.
>
In the Oracle world, if I recall, materialized views must use tables
as underlying objects - ie., they cannot be based on views.
>
Does the same hold in db2 (8.2 LUW, 8 z/OS)?
>
I'm looking in SQL reference 2 about the syntax for the fullselect,
and although I suspect by the wording that I am correct, I'm not
finding a specific statement such that an underlying object referenced
by the fullselect cannot be a view.
>
I'll keep looking...
>
Tx,
>
BD.

Cancel that - nothing beats trying it yourself, I guess. Looks to work
fine.

Sorry - should have just tried it and not posted. Oh well.