What should I bear in mind for COLUMN > (blank) queries?
Bear in mind the following for SQL statements of the type COLUMN > ‘ ‘ : If COLUMN is a part of a multiple key or index, and is not the last column in this key or index, then, because of its architecture, MaxDB must search through, not only all rows that contain > ‘ ‘, but also all of the rows that are blank in COLUMN. You can optimize such statements by creating a single index using COLUMN or by creating a multiple index, in which COLUMN is the last index field.
