Defining columns as NULL or NOT NULL helps the optimizer work more efficiently.
Specifying NULL or NOT NULL allows the optimizer a more educated guess at joins and search criteria by having one more piece of information about the characteristics of the data. NULL data does not save space on the database page, as it would in other databases. NULL data will, however, be compressed out when stored on disk due to the SAP Sybase IQ compression algorithms and optimized indexes.