(Willie Favero) RELEASE (DEALLOCATE) changes a few of the rules when it comes to releasing storage. For example, even if you choose to use the DSNZPARM keyword CONTSTOR in attempt to take advantage of storage contraction, RELEASE(DEALLOCATE) negates the entire process. A commit does not trip CONTSTO
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help