Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Tkprof output question

Re: Tkprof output question

From: <sybrandb_at_yahoo.com>
Date: 25 Nov 2004 06:33:28 -0800
Message-ID: <a1d154f4.0411250633.23ac34d6@posting.google.com>


"Yaakov Berkovitch" <jaakovb_at_corrigent.com> wrote in message news:<co4eis$ec3$1_at_news2.netvision.net.il>...
> Hello,
>
> To those that have experience using the 'alter session sql_trace=true' and
> the tkprof, I have
> a simlpe question.
>
> If I saw in the ouptut generated by tkprof,
> Rows Row Source Operation
> ------- -----------------------------------------------------
> 672 TABLE ACCESS FULL OBJ#(6817)
>
> is that says that the SQL request doesn't use the index ?
>
> Thanks for any tips.
>
> Yaakov Berkovitch
> jaakovb_at_corrigent.com

It doesn't use any index. Given the tiny number of rows, it is debatable whether using any index would be advantageous. You'll need at least 3 I/O requests for any index lookup, and probably you can read the entire table in memory with one single multiblock read.

--
Sybrand Bakker
Senior Oracle DBA
Received on Thu Nov 25 2004 - 08:33:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US