Re: Help! Server Tuning/speed/optimization
From: Martin J. Malley <mmalley_at_radiks.net>
Date: 1997/09/05
Message-ID: <01bcb991$3eaf3ec0$8f4303cf_at_gateway>#1/1
Date: 1997/09/05
Message-ID: <01bcb991$3eaf3ec0$8f4303cf_at_gateway>#1/1
> 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.
-
[Quoted]
- If you are using the Cost Based Optimizer make sure statistics are current.
- Look at your explain plans to see if your query is using indexes appropriately.