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 - 14:58:40 CST
