Re: tkprof - disk reads greater than query+current

Jonathan,

This is a Oracle text query - uses DOMAIN index. select * from ( select a.*, rownum rnum from ( select /* +FIRST_ROWS(21)*/
columnA, columnB, columnC, create_date from tableName where

   contains ( columnD, 'MICROSOFT') > 0 and    create_date between sysdate - 180 and sysdate order by create_date desc ) a

   where rownum <= 21) where rnum > 0;

Thanks
wagen Received on Fri Apr 20 2007 - 15:00:40 CDT