Re: ORDER BY performance problem

From: <cholman_at_my-deja.com>
Date: Tue, 10 Aug 1999 21:20:13 GMT
Message-ID: <7oq522$vn1$1@nnrp1.deja.com>

It could make a difference to place an index on the ordered column.

Candace

> On Mon, 09 Aug 1999 13:43:50 GMT, franz.mueller_at_orbis.de (Franz
> Mueller) wrote:
>
> >Hi,
> >
> >I have a performance problem with a query that ends with "ORDER BY
.."
> >Without the ORDER BY it runs really fast. The difference is really
big
> >(on an answer set with 200 rows). Is there a way to speed up this
kind
> >of query?
> >
> >Franz
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Aug 10 1999 - 16:20:13 CDT