Return-Path: <oracle-l-bounce@freelists.org>
Delivered-To: 2-oracle-l@orafaq.com
Received: (qmail 25085 invoked from network); 7 Jul 2006 09:06:19 -0500
Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180)
  by 69.64.49.119 with SMTP; 7 Jul 2006 09:06:19 -0500
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id ECA353935E0;
 Fri,  7 Jul 2006 10:06:11 -0400 (EDT)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 07210-08; Fri, 7 Jul 2006 10:06:11 -0400 (EDT)
Received: from turing (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 73ED239336A;
 Fri,  7 Jul 2006 10:06:11 -0400 (EDT)
Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 07 Jul 2006 10:05:24 -0400 (EDT)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 15955393419
 for <oracle-l@freelists.org>; Fri,  7 Jul 2006 10:05:24 -0400 (EDT)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 07096-01 for <oracle-l@freelists.org>;
 Fri, 7 Jul 2006 10:05:24 -0400 (EDT)
Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.190])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A48F739321C
 for <oracle-l@freelists.org>; Fri,  7 Jul 2006 10:05:23 -0400 (EDT)
Received: by nf-out-0910.google.com with SMTP id k27so104919nfc
        for <oracle-l@freelists.org>; Fri, 07 Jul 2006 07:05:30 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:mime-version:content-type;
        b=FEo7hLET4tLYURW3idXHqImfCskHS20160BZrum/JtBetBki3735UOPFgGLqiG1Gb8Q7rQ4RS4M+dw541VCzKkNvTAHJ7/7XMtFgwBY0pUJzUjVVwLM0pieS55gIamXPnLQ89ROOrOy8DXLNWxxjkBcJkwk9/wfVLkvHz52Pm0Y=
Received: by 10.78.178.5 with SMTP id a5mr685736huf;
        Fri, 07 Jul 2006 07:05:29 -0700 (PDT)
Received: by 10.78.135.4 with HTTP; Fri, 7 Jul 2006 07:05:29 -0700 (PDT)
Message-ID: <8cb0040f0607070705l4f56f7afuf65e3ba720ab3180@mail.gmail.com>
Date: Fri, 7 Jul 2006 15:05:29 +0100
From: "Stuart Clowes" <stuart.clowes@gmail.com>
To: oracle-l@freelists.org
Subject: Access path: index (stp-guess)
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_27293_20502104.1152281129871"
X-archive-position: 36825
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
X-original-sender: stuart.clowes@gmail.com
Precedence: normal
Reply-to: stuart.clowes@gmail.com
X-list: oracle-l
X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.net
------=_Part_27293_20502104.1152281129871
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Can anybody tell me what this access path I'm seeing in a 10053 trace file
is?

index (stp-guess)

I'm seeing it when I'm missing column statistics on my table.


Stuart

------=_Part_27293_20502104.1152281129871
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>Can anybody tell me what this access path I'm seeing in a 10053 trace file is?</div>
<div>&nbsp;</div>
<div>index (stp-guess)</div>
<div>&nbsp;</div>
<div>I'm seeing it when I'm missing column statistics on my table.</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div>Stuart</div>

------=_Part_27293_20502104.1152281129871--
--
http://www.freelists.org/webpage/oracle-l