Re: Intrepretation of 10053 trace

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 23 Sep 2004 21:56:22 +0000 (UTC)
Message-ID: <civgq6$pkp$1@titan.btinternet.com>

Note in-line.

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated Sept 19th





"Pk" <pbhandari2050_at_yahoo.com> wrote in message
news:fa93fdc3.0409231248.482048b7_at_posting.google.com...


> The index is a concatenated two column index, B*Tree.

>


I know it's your database, but I'm not sure you're right.
According to the trace file:
    Col #4 is the only column in the index.

INDEX NAME: OUT_ORD_HDR_AK_8  COL#: 4
    TOTAL ::  LVLS: 2   #LB: 680  #DK: 6  LB/K: 113  DB/K: 4017  CLUF: 24107



>>  What kind of index is OUT_ORD_HDR_AK_8 ?

Received on Thu Sep 23 2004 - 16:56:22 CDT