V$SQLAREA Stats Bug?

From: John P. Higgins <jh33378_at_deere.com>
Date: Fri, 26 Feb 1999 11:29:14 -0600
Message-ID: <36D6D9EA.598E23E2@deere.com>

The V$SQLAREA contains a row for this (simplified) query:

SELECT * FROM ___ WHERE C1=:a AND C2=:b AND C3=:c AND C4=:d AND C5=:e;

There is a primary key index on C1, C2, C3.

The explain plan does show an index unique scan using the primary key index.

The V$SQLAREA stats for this statement are: EXECUTIONS = 1,471,320
ROWS_PROCESSED = 37,291,384 How is it possible to use a unique index scan and return more than 1 row per execution? Or is there a problem with the stats? Received on Fri Feb 26 1999 - 11:29:14 CST