Re: Performance problem and the solution

You know, most users underestimate the importance of mass-storage lubrication. Try a little drive-spindle grease before you go through all the trouble of re- formatting - you'll probably notice 50 - 100% improvement, depending on the age of your drives.

In article <7e08fl$q3s$1_at_brokaw.wa.com>,   "paulOsborn" <paul.osborn_at_aris.com> wrote:
> 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
> >
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Apr 01 1999 - 14:04:24 CST