>I sent through a change request to the article to use Sergey's algorithm of
>
>alter table ... add column ...
>alter table ... drop column ...
>
>rather than pack. I like it better, you don't have to worry about losing deleted records if you want to retain them for some reason, and it works even if there are no deleted records.
It seems to me that adding columns will require a significantly greater amount of work than simply adding a record. Rewriting every record in the table twice could have a huge impact on large tables.
Not suggesting one over the other, just realizing the possibilities...
Chris.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement