Re: Running UPDATE STATISTICS on a table being used

Posted in 1997

Gert Brinkmann — Fri, 21 Nov 1997 10:45:29 +0100 — source: Informix-list mailing list archive (1991-1998)

sujata_soman_at_omm-la2-infotech-001@internet.omm.com wrote: > Since the update statistics was going on parallelly with the query, will the > query use the new plan once the update statistics is over or does it still go > with the old plan ?? The query is just taking for ever to complete, and I am Hello, i am not sure, but i think that the query that is already running will not be reoptimized. The optimizer builds the query-plan at the beginning of a submitted query. Gert. -- Gert Brinkmann email: gbrinkmann@dimedis.de Software Development tel: 0221/921260-0 dimedis GmbH fax: -99 Habsburgerring 2-12 http://www.dimedis.de 50674 Koeln http://www.RealTimeImage.de

Related threads

Using a "+" character in an SQL insert statement?
Re: Delay in commands returning