Обсуждение: 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