DB2 LUW optimization level question

Deepak Goyal

DB2 LUW optimization level question
Hi,

Do we have to specify any minimum query optimization level so that DB2 can
consider using MQT ?

For example, DFT_QUERYOPT should be 5 or more to DB2 to consider MQT.

Thanks

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

DB2 DBA Jeffrey Benner

Re: DB2 LUW optimization level question
(in response to Deepak Goyal)
I use a MQT as an object of a direct query and as a result the optimization
level doesn't matter. Otherwise I agree with your recitation of the
documentation - that is what it says.

On Wed, Dec 10, 2008 at 16:19, Deepak Goyal <[login to unmask email]> wrote:

> Hi,
>
> Do we have to specify any minimum query optimization level so that DB2 can
> consider using MQT ?
>
> For example, DFT_QUERYOPT should be 5 or more to DB2 to consider MQT.
>
> Thanks
>
> ______________________________________________________________________
>
> * IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
> ______________________________________________________________________
>
>
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L
> list archives, FAQ, and delivery preferences are at
> http://www.idug.org/lsidug under the Listserv tab. While at the site, you
> can also access the IDUG Online Learning Center, Tech Library and Code
> Place, see the latest IDUG conference information and much more. If you
> have not yet signed up for Basic Membership in IDUG, available at no cost,
> click on Member Services at http://www.idug.org/lsms
>
>

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Deepak Goyal

Re: DB2 LUW optimization level question
(in response to DB2 DBA Jeffrey Benner)
I am just curious but why would you like to query MQT directly ? If I have to
query MQT directly means changing my query but without changing my query
the only way to use MQT is through query optimization only.

Thanks

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

DB2 DBA Jeffrey Benner

Re: DB2 LUW optimization level question
(in response to Deepak Goyal)
I use a materialized view because a single query was run with very high
frequency at very high performance cost. By changing a view to a MQT I
heavily reduced the cost of running this query on the system by eliminating
several expensive joins between several tables with static data.

On Thu, Dec 11, 2008 at 14:22, Deepak Goyal <[login to unmask email]> wrote:

> I am just curious but why would you like to query MQT directly ? If I have
> to
> query MQT directly means changing my query but without changing my query
> the only way to use MQT is through query optimization only.
>
> Thanks
>
> ______________________________________________________________________
>
> * IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
> ______________________________________________________________________
>
>
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L
> list archives, FAQ, and delivery preferences are at
> http://www.idug.org/lsidug under the Listserv tab. While at the site, you
> can also access the IDUG Online Learning Center, Tech Library and Code
> Place, see the latest IDUG conference information and much more. If you
> have not yet signed up for Basic Membership in IDUG, available at no cost,
> click on Member Services at http://www.idug.org/lsms
>
>

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms