Re: Do selects fill logical logs?

Andrew, I am not sure where this is documented, but the facts as I understand them are: When a subquery is processed, a temp table is created and dropped for each row in the main query. By default, temp tables are created with logging, so correlated subqueries generate large logs. While you can CREATE TEMP ... WITH NO LOG and you can SELECT ... INTO TEMP WITH NO LOG, I know of no way to turn off logging for a correlated subquery. This would be a very useful (and probably not very difficult, assuming the engine architecture is reasonably sane) feature. Anyone at Informix listening? Andrew Cilia wrote: > > I am currently investigating an incident on a 5.03 ONLINE > engine where a select statement with a correlated subquery > seems to populate the logical logs. Reputable sources tell > me that this is standard procedure on complicated queries. > Can anyone confirm this? Where is it documented? > Precisely under what conditions are logs used by queries. > Why does it need to be this way? > -- -------------------------------------------------------------------------------John Prideaux e-mail: alastl@ix.netcom.com Phone: (217)839-2121 Aladdin Steel, Inc. Fax: (217)839-4327 -------------------------------------------------------------------------------