Query Generation for no apparent reason??

37 Views

When looking at the statistics in 0TCT_C02, we have noted that our queries regenerate or optimize multiple times each day. I have tested this with a single query and I was sure to go into RSRT and turn off the optimization option. Exceedingly longs times in 0TCT_C02 for event 3010 (OLAP: Query Generation). We are talking times on the order of 45 seconds. I know that each query is supposed to be regenerated once every 31 days by default. What else could be triggering this behavior?

Examples:

Date Time (HH:MM) OLAP Gen Time (3010) from view RSDDSTAT_OLAP

11/10/08 00:00 0.207153

11/10/08 01:06 46.295823

11/10/08 02:17 0.382898

11/10/08 02:22 0.047491

11/10/08 03:00 0.527515

11/10/08 03:00 0.037425

11/10/08 03:00 0.031306

11/10/08 03:00 0.031065

11/10/08 03:00 0.030289

11/10/08 12:26 27.802359

11/10/08 12:56 0.148548

11/10/08 13:04 0.255053

11/10/08 13:08 0.345807

11/10/08 13:08 0.033123

11/10/08 13:08 0.032887

11/10/08 13:14 0.448533

11/10/08 13:14 0.074349

11/10/08 13:14 0.043456

11/10/08 13:14 0.040294

Why would it regenerate multiple times a day? How do we get this to stop or at least control it better?

(The query itself has not been changed since August of this year).

Thanks for any info:

Mitchell