Yes, we tried the same approach with similar results. If you reformat your
hard drives you should have no more problems.
Nuno Souto wrote in message <7e05j9$flp$1_at_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:50:16 CST
