Will setting BLOB to NULL free disk space
From: Johan Hellstrom <xtrnjot_at_nospam.hotmail.com>
Date: Tue, 28 Oct 2003 10:34:49 -0000
Message-ID: <bnlgmd$3fe$1_at_newstree.wise.edt.ericsson.se>
Date: Tue, 28 Oct 2003 10:34:49 -0000
Message-ID: <bnlgmd$3fe$1_at_newstree.wise.edt.ericsson.se>
If a BLOB column has around 10 MB of data in it and it is set to NULL, would the storage needed to store the record be reduced by 10 MB?
Additionally would it leave room for another 10 MB of data on the file system? or would the DBMS still "claim" this space for another purpose?
If this is not the case, is there an alternative preferred way of freeing up disk space used by LOB data for other purposes?
Kind Regards
Johan Hellstrom Received on Tue Oct 28 2003 - 11:34:49 CET