Re: Index help

From: Terry Sutton <terrysutton_at_usa.net>
Date: Fri, 23 Jul 2004 15:12:51 -0700
Message-ID: <02e901c47102$38492ed0$51f5a8c0@TerrySutton>

OK, we've established that I wasn't awake enough to notice there were 29 executions, but I'm still confused about the "primary key" thing. You say ida3a5 is the primary key. That means you have an index on it. Unless I'm still reading wrong, your query has a "(A0.idA3A5 = :1)" predicate. Seems to me that would indicate 1 index lookup and 1 row lookup. As Daniel points out, most of your executions return no rows, so the other predicates aren't satisfied. But I don't see how you would ever get a full scan instead of a primary key lookup.

--Terry

• Original Message ----- I may be blind (no coffee yet), but you're doing a select with the primary key in the where clause and you get 4 rows? Something's wrong here.

--Terry

• Original Message ----- From: "M.Godlewski" <mcgodlewski_at_yahoo.com> To: <oracle-l_at_freelists.org> Sent: Friday, July 23, 2004 8:43 AM Subject: RE: Index help

row count for table 5108
primary key on table (ida3a5) has 5108 distinct_keys codec5 has 3 distinct values.
scheduletime has 4781 distinct values.

---

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

---

---

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 Fri Jul 23 2004 - 17:09:35 CDT