[Info-ingres] RES: RES: [Info-ingres] temporary table

#1 (**permalink**) 04-20-2008, 08:03 PM

> Before executing a query plan, the tables involved are checked to see
> if they have changed. Changed in this case means that either
> the table
> definition changed, or the number of pages (table size) has changed
> sufficiently. (I'm not sure what the trigger is.) When this happens,
> QEF throws away the query plan and sends the query back
> through parsing and optimization again.
>
> If this happens more than N times in a row without a successful
> execution, the US1265 message appears. N used to be small, like 3;
> I'm fairly sure that it's 10 in 2.6. About the only legitimate reason
> for US1265 to appear is if a table in a query is growing rapidly,
> or being modified over and over. DB procedures are probably more
> sensitive to US1265 since they're one big query plan. If you have
> a persistent US1265, I would be very suspicious.
>
> Karl

Thanks Karl for the explanation. This clarifies a lot. Certainly
the tables envolved in the query triggers some DB procedures, and
these tables are growing rapidly as you said. The query have many
inserts from temporary to physical tables.

Leandro Fava
DBA-SINF-UNISC http://www.unisc.br
Presidente IUG-BR http://www.iug-br.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode