Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tkprof output question
"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 DBAReceived on Thu Nov 25 2004 - 08:33:28 CST