SQL Server view takes a long time to alter but query itself finishes quickly?
Make sure there's no contention for that view. If something else is accessing it, or if there's a spid somewhere that's idle but has a connection to it, you may be blocked from the ALTER
statement.
A simple sp_who2 active
during the ALTER
should give you the culprit.