SQL*ReportWriter order by clause
From: Neil Greene <deepthought!neil_at_ms.uky.edu>
Date: Fri, 25 Sep 1992 17:07:36 GMT
Message-ID: <1992Sep25.170736.2535_at_deepthought.uucp>
Date: Fri, 25 Sep 1992 17:07:36 GMT
Message-ID: <1992Sep25.170736.2535_at_deepthought.uucp>
I have an oracle database with approximatley 500,000+ records consisting
of lname, fname, mname, ss, birthdate.
I would like to sort these records in lname, fname order. However,
sorting this many records in this fashion seems to take forever. Closer
magnitude of non-existant.
Is there some way I may better optimise the use of indexes?
I have the following index, but things are still S_L_O_W:
> create index I_MASTER$FLNAME on
> MASTER(LNAME, FNAME)
> TABLESPACE NASRIS_INDEX
> PCTFREE 10
> storage (initial 10M next 1M
> maxextents 99
> pctincrease 0);
Received on Fri Sep 25 1992 - 19:07:36 CEST