Hi

> What we have speculated about in the past is extending EXPLAIN
> so that it can be applied to ALTER TABLE and other complicated
> utility commands, and then for ALTER TABLE one bit of info it would
> give you is whether a table rewrite (or even a table scan) is
> required.  Obviously, that's a major project, and so nobody's
> tackled it yet AFAIK.
>

I though same idea, using EXPLAIN for this purpose can be nice and intuitive

Regards

Pavel



>
>                         regards, tom lane
>

Reply via email to