Обсуждение: seeking: advice on reordering table

I've drastically altered a few tables in a major schema change.
because of this, some columns that i'd really like to be 'leftmost'
are rightmost.

can anyone suggest a good way to reorder the table ?  everything that
i can think of involves creating a new table which means I'd have to
redo all the constraints .


// Jonathan Vanasco

| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - -
| SyndiClick.com
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - -
|      FindMeOn.com - The cure for Multiple Web Personality Disorder
|      Web Identity Management and 3D Social Networking
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - -
|      RoadSound.com - Tools For Bands, Stuff For Fans
|      Collaborative Online Management And Syndication Tools
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - -

On 4/12/07, Jonathan Vanasco <postgres@2xlp.com> wrote:
> can anyone suggest a good way to reorder the table ?  everything that
> i can think of involves creating a new table which means I'd have to
> redo all the constraints .
The common thing to do is to write your query in such
a way that what interests you most is put left ...

> // Jonathan Vanasco
Cheers,
Andrej

Andrej Ricnik-Bay wrote:
> On 4/12/07, Jonathan Vanasco <postgres@2xlp.com> wrote:
>> can anyone suggest a good way to reorder the table ?  everything that
>> i can think of involves creating a new table which means I'd have to
>> redo all the constraints .
> The common thing to do is to write your query in such
> a way that what interests you most is put left ...
>
>> // Jonathan Vanasco

Create a clustered index on the attribute you want it ordered by. (I'm
not sure is a clustered index can be a composite, but the docs or
someone else here will let you know :-)

Note that any inserts (or updates on the attr with the clustered index)
will cause the ordering to be broken, in which case you'll need to
re-cluster.

Cheers,

  Brent Wood