Re: Index help

From: Daniel Fink <Daniel.Fink_at_Sun.COM>
Date: Mon, 26 Jul 2004 07:21:11 -0600
Message-id: <41050547.6090203@sun.com>

Since the PK is not being used in the predicate, my original posting is correct. Without knowing what indexes exist/don't exist, it is very difficult to determine why a FTS is being done when there is an equality predicate. How many distinct values does IDA3A5 have?

Daniel

M.Godlewski wrote:
> Sorry about the PK confusion. I was wrong about the IDA3A5 as the primary key. In some tables in this schema IDA3A5 is the primary key. In this table however it is IDA2A2.
>
> There are no stored outlines in use.
>

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Jul 26 2004 - 08:17:50 CDT