Re: Index help
- From: "M.Godlewski" <mcgodlewski@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 26 Jul 2004 06:32:26 -0700 (PDT)
6 distinct values for ida3a5
Daniel Fink <Daniel.Fink@xxxxxxx> wrote: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
-----------------------------------------------------------------
---------------------------------
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
----------------------------------------------------------------
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:
