pre-sroted table (w/ index)

From: Vic Cekvenich <cekvenich(dot)vic(at)portalvu(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pre-sroted table (w/ index)
Date: 2004-10-07 16:30:37
Message-ID: ck3r0j$cq9$1@sea.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In TransacSQL, we used to have the tabled sorted by marking an index for
example by create_date.

This way we did not need to do an order by or at least it was faster.

Is there a way to force the table to be physicaly stroed sorted by a
certain index?

tia,
.V

Responses

Browse pgsql-general by date

  From Date Subject
Next Message William Yu 2004-10-07 16:30:59 Re: PostgreSQL seems to wait and block all the queries
Previous Message Ian E. Morgan 2004-10-07 16:14:48 Alternate interval output function