Looks like the cache subsystem of the T2000 is pretty good so the local (in relation to a cache) algorithms can benefit.
Thanks to Kevin Closson - my theory about what it's the Niagara cache that helps it out was wrong. declare l_x dual.dummy%type; begin for i in 1 .. 500000 loop select dummy into l_x from dual; end loop; end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1 133.29 134.92 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 133.30 134.92 0 0 0 1 Pretty much the same numbers as from my "lookup-table" tests. -- Alexander Fatkulin -- //www.freelists.org/webpage/oracle-l