Re: Another intriguing one...

In article <5vbk58$n5r@cssun.mathcs.emory.edu>, Mark Collins <mcollins@us.DHL.COM> writes >} >Here's one: under 5.x on Solaris and SunOS, they claim to get SELECTs >} >from VIEWs recorded in the logical logs, whereas SELECTs from base >} >tables (quite rightly) do not appear in the logical logs. Are they >} >smoking their proverbial socks, or is there some justification for >} >this bizarre claim? >} > >} >All comments gratefully received... >} > >} >} Corelated subquery, mate, built temporary tables as it processes 'em. >} >} snip... > >} Engine effectivly runs the subqueries for each value of col1 within >} the table i.e. for each row in the table. This involves creating and >} dropping a temp table for each row in the table (to hold the query >} results before doing the col < ALL bit). >} > >Under version 7.x, if one has correctly defined temporary dbspace(s) as >non-logged, does a correlated subquery produce any log records? > Not sure, but since when a database has no logging defined DML statements e.g. create table, drop table still get logged I would assume so. > > >Mark Collins >mcollins@us.dhl.com > > -- David Williams