Re: Index help
- From: Daniel Fink <Daniel.Fink@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 26 Jul 2004 07:21:11 -0600
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
