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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
