Re: Performance problem and the solution

That spindle grease can really play havoc with any floppies that are located near the hard drives. You might try recentering any labels on the drive cases to bring them into better balance. It's easier and as a bonus your drives will look neater when you're done.

Van

Gerard M. Averill wrote in message <7e0mcv$m7q$3_at_news.doit.wisc.edu>...
>In article <7e05j9$flp$1_at_m2.c2.telstra-mm.net.au>, "Nuno Souto"
<nsouto_at_nsw.bigpond.net.au> wrote:
>>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?
>>
>We've always just added '... and rownum = 1' to all the SELECT's; that way
>only the first row is read, rather than the whole table.
>
>G.
>
>----
>Gerard M. Averill, Researcher
>CHSRA, University of Wisconsin - Madison
>GAverill<at>chsra<dot>wisc<dot>edu
Received on Thu Apr 01 1999 - 18:00:28 CST