Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Performance on Netware 7.3 ( Or Lack Of)
BC Computing Limited <BCCOMP_at_bccomp.demon.co.uk> wrote:
> Hi,
>
> Can anyone suggest a cause for the following problem :
>
> I have 32,000 records in a table, to produce a total value
> of these records takes 1 min 32 sec.
>
> When I had 31,500 records it took 1 min.
> when I had 31,000 records it took 30 sec.
> when I had 30,000 records it took 3 sec.
>
> I'm running Oracle 7.3 for Netware and Forms 4.5 V1.2.1
>
> I would be very grateful if anyone can tell me what's happening
> here because I just can't work it out !!!
>
>
> Cheers
> Chris Prince
>
> \\||//
> (@ @)
> +------------------------------------ooO-(^/)-Ooo------------------+
> |Chris Prince, Systems Analyst | BC Computing Limited |
> |Tel +44 1924 - 223375 | Ripley Drive |
> |Fax +44 1924 - 223376 | Normanton Industrial Estate |
> |Email - CHRIS_at_bccomp.demon.co.uk | Normanton |
> | | West Yorkshire |
> |Thanks in Advance %-) | WF6 1RY |
> | | UNITED KINGDOM |
+------------------------------------------------------------------+try again...
> |The views / information expressed within this document are my own,|
> |and therefore not neccessarily those of BC Computing Limited. |
> +------------------------------------------------------------------+
Try to create an non-unique index in the computed columns and
This is the unique solution that I can think bacause of, as your select is with only one table, the cost or rule approach will have rthe same effect.
Regards,
-- Luis Santos Relacional Consultoria Rio de Janeiro - BrazilReceived on Sun Mar 23 1997 - 00:00:00 CST