Results 1 to 2 of 2

Thread: loading tables

  1. #1
    Join Date
    Nov 2007
    Posts
    72

    Unanswered: loading tables

    Hi,
    I am trying to load summary table from base tables but its taking lot of time ..what all are the options which i can explore to cut short on time ...will query patroller will help ( my guess is it will allow me to define classes)only.

    Regards.

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Do you have applied the necessary performance tuning applicable for the query that you used to define the MQT?

    The thing is that DB2 has to execute this query to get all the data, then populate the MQT with that data. And if executing the query is slow, populating the MQT will be slow as well.
    Last edited by stolze; 06-01-08 at 09:11.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •