Slow Views...

From: Mitchell Baldwin <Mitchell.Baldwin_at_cogent-dsn.com>
Date: Fri, 18 Jun 2004 12:26:21 +0100
Message-ID: <A5E49A0595FB4A489ED566217349B1472DBA3E@zaphod1.cogent-dsn.local>

Hi All

I have a strange problem with some views on an 8.1.7 database (Solaris 8)

I have a top level view that unions 3 other views which is taking many minutes to return, but the SQL from the sub views is returning in a total of 20secs for all three queries.

Now the strange thing is the sub views are also going incredibly slow compared to the underlying SQL.

I have made sure all the joins are indexed and have analysed the explain plan, and its only doing index range scans.

I've also added the hint /* +RULE */ to stop hash joins.

I know there is an overhead for the views on views, but this seems a bit to much !..

TIA Mitch

---

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 Jun 18 2004 - 06:22:41 CDT