Re: Performance on Netware 7.3 ( Or Lack Of)

From: Luis Santos <lsantos_at_pobox.com>
Date: 1997/03/23
Message-ID: <3336a15c.2347622@news.centroin.com.br>#1/1

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 |

 +------------------------------------------------------------------+


> |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

try again...

        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 - Brazil

Received on Sun Mar 23 1997 - 00:00:00 CST