I understand that boolean values can be represented in db2 using either a
SMALLINT or CHAR(1) data type.
-- Is one option better from a query-efficiency/computational-efficiency
perspective?
-- If so, how much better (in percentage or just general order of
magnitude terms)?
What situations are there, if any, in which the answers to these two
questions differ?

Best regards,
Steve Cary


DB2 & UDB email list listserv db2-l LazyDBA home page