RICHINMINN
Programmer
- Dec 31, 2001
- 138
Platform: IBM MVS mainframe running DB2 v9
Given: a table contains a column which is defined as VARCHAR(20), and which is nullable
Question: Which is more efficient (or simply better for whatever reason): 1) to use the NULL indicator to indicate the absence of a value in that particular column, or 2) to set the length of the field to 0 (zero)?
Thanks for your input!
RichinMinn
Given: a table contains a column which is defined as VARCHAR(20), and which is nullable
Question: Which is more efficient (or simply better for whatever reason): 1) to use the NULL indicator to indicate the absence of a value in that particular column, or 2) to set the length of the field to 0 (zero)?
Thanks for your input!
RichinMinn