Does ALTER TABLE <table> ALTER <field> SET STATISTICS 100; lock the table? I just tried to do that while a query is running and the ALTER is hanging.