Re: Quickly making a column non-nullable (without a table scan)

Joe Van Dyk wrote:

> I have an index on a column that can be nullable. I decide the column
> shouldn't be nullable anymore. So I alter the column to be not
> nullable.
>
> That "alter column" query does a full table scan, which can be painful
> for large tables. Couldn't that index be used instead?

Interesting idea, but I'm pretty sure we don't yet have such logic.

-Kevin