[ Marcus, you should folow up to the lists, so that other people can benefit from the discussion ] On fim, 2006-12-07 at 09:25 +0100, Marcus Engene wrote: > Ragnar skrev: > > 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. > >> > >> SELECT Field1, Field2, Field3... FieldN FROM TargetTable ORDER BY Field1 > >> DESC; > > > > > > you might consider CLUSTER > > Would putting the index on a separate tablespace on another harddisk > have a similar effect? we haven't had any real information from the OP. as far as I can tell, he has not answered any questions about his case, so we really have no idea where his problem is. if he has extra harddisks that are not used, there may be many ways of taking advantage of that. gnari
