Re: Help! Server Tuning/speed/optimization

From: rahmu <sathya_at_flash.net>
Date: 1997/09/10
Message-ID: <3415E4C8.838_at_flash.net>#1/1

Martin J. Malley wrote:
>
> > Does anyone know of some simple strategies for optimizing a database?
> >
> > Queries that return under 1000 records take about 1 minute. In user time
> > that's way too long. We have an average of 20,000 records in the tables
 we
> > are testing. We are using a Developer 2000 (forms 4.5) front end and the
> > database is version 7.3.2.2.1.
>
> 1. If you are using the Cost Based Optimizer make sure statistics are
> current.
>
> 2. Look at your explain plans to see if your query is using indexes
> appropriately.

---

Do you have primary key? I think you need a primary key for your tables. Received on Wed Sep 10 1997 - 00:00:00 CEST