Tim

I hope that moving columns about even when there's lots of data doesn't take much time eg

ALTER COLUMN "_ID" MOVE TO 7,
ALTER COLUMN "_ID" MOVE TO 6,
ALTER COLUMN "_ID" MOVE TO 5,
ALTER COLUMN "_ID" MOVE TO 4,
ALTER COLUMN "_ID" MOVE TO 3,
ALTER COLUMN "_ID" MOVE TO 2,
ALTER COLUMN "_ID" MOVE TO 1,

Roy Lambert

Roy,

<< I hope that moving columns about even when there's lots of data doesn't
take much time eg >>

ALTER TABLE operations are executed all at once on the catalog information
and *then* the table data is moved over.  The operations aren't executed one
at a time on the data.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


Good - that actually made sense to me - I must be improving.

Roy Lambert

Roy,

<< Good - that actually made sense to me - I must be improving. >>



The key to understanding the new architecture in EDB is to simply always
remember that the catalog is the king.  It determines everything.

--
Tim Young
Elevate Software
www.elevatesoft.com