Re: Anything I can do to speed up this query?

On mið, 2006-12-06 at 17:34 -0500, Wei Weng wrote:
> On Tue, 2006-12-05 at 15:56 -0500, Wei Weng wrote:
> > I have a table that has roughly 200,000 entries and many columns.
>...
> I think I have discovered the reason for why the query runs so slow. The
> original query has an ORDER BY Field1 clause that I forgot to put in my
> email.
>
> SELECT Field1, Field2, Field3... FieldN FROM TargetTable ORDER BY Field1
> DESC;
>

in that case you did not provide us with a useful
explain analyze

> What is the effective way to optimize this query(or to optimize the
> system) to run a little faster than it does now?


you might consider CLUSTER


gnari