Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: tkprof - disk reads greater than query+current
On Apr 20, 4:00 pm, wagen..._at_yahoo.com wrote:
> 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
Try using a tool like the hotsos resource profiler or the open source clone orasrp these will include a breakout that does correctly show the costing of the queries against a text index. Received on Fri Apr 20 2007 - 18:57:22 CDT