Re: Another intriguing one...

} >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? Mark Collins mcollins@us.dhl.com