Re: Another intriguing one...

In article <5v68f6$cjp@cssun.mathcs.emory.edu>, Billy Wheeler <billy@west.co.za> writes >G'day all. > >I'm giving a training course at the moment to a bunch of long-time >OnLine 5 users, and boy, am I getting asked some interesting >questions! :-) > >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. E.g. select col1,col2 <- col1 in select clause here from tab1 where col2 < ALL (select col3 from tab1 where col1 = col3) <- same col1 in where clause of subselect. 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). >-- >Ciao, >Billy > >Nose to the ear in Dubai, home of sun, fun and 100% humidity... >For a good time, call: http://www.iiug.org/techinfo/faq/faq_top.html -- David Williams