Re: pre-sroted table (w/ index)

On Thu, Oct 07, 2004 at 11:30:37AM -0500, Vic Cekvenich wrote:
> 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.

You'll always need to do an order by, as there's no guarantee of the
order of the results received. It may work today, but it may not tomorrow.

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

Look in the manual for the SQL command 'CLUSTER'. It doesn't keep a
table ordered on disk as new inserts happen (it's very inefficient to
do so) but it'll order the existing data, which will often speed up
queries that return quite a lot of data from an index scan.

Cheers,
Steve