We are defining all our new tables for the new system using DDL and using
nulls where appropriate. My question has to do with Nulls and Indexes.
Has anyone seen a discussion of how the iSeries handles null and indexes? I
ran the following query and checked the low level messages and it indicated
that it was using the foreign key index to return the results. Just wondered
if there was more information at their on how nulls are handled in an index.
Where OPERATING_STATUS Is Null