>What can cause a table to take around 20 seconds just to open? (it's not a view)
Could it be corrupted table? Is it part of database? Can you select everything from it to a cursor, zap the original, insert from the cursor?
If it's not broken, fix it until it is.
My Blog 
