| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Index help
6 distinct values for ida3a5
Daniel Fink <Daniel.Fink_at_Sun.COM> 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.
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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_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:29:34 CDT
 |
 |