RE: Michael Schmid number of pages read during sequential scans

Michael Said >The test session finds out its session id (select dbinfo('sessionid') from table(set{1})). Very nice. I always used select dbinfo('sessionid') from systables where tabid = 1; For the "dual" equivalent. Thanks for the tip. Any performance penalty to do it this way? Not that it matters much since This isn't usually done in a loop. So I created the view create view dual(c) as select * from table(set{1}); -- For the Oracleguy starting next week so he doesn't get too confused.