Performance problem and the solution

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au>
Date: Fri, 2 Apr 1999 02:00:34 +1000
Message-ID: <7e05j9$flp$1@m2.c2.telstra-mm.net.au>

Sydney, 1st April 1999

Hi all. We had this HUGE problem with SELECTs on all our tables taking a looong time.

Purely by accident, we found out that a SELECT from DUAL was much faster. So we replaced all tables in our application's SQL by DUAL. Guess what?

It all works so fast now we can hardly see the screen results!

Yet I still ran an EXPLAIN PLAN on our SQL. We are still doing the dreadful TABLE SCANS. Does anybody know of a good way to index the DUMMY column in DUAL so we can stop this FULL TABLE SCAN nonsense? Any ideas on sizing, tablespace split and so on for even better performance?

TIA --
Cheers
The April Guru
Nuno Souto
nsouto_at_nsw.bigpond.net.au
http://www.acay.com.au/~nsouto/welcome.htm Received on Thu Apr 01 1999 - 10:00:34 CST