Comments - IS NULL and IS NOT NULL predicates
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
Yes, also the extent elimination generally works best for columns that are ascending over time like surrogate ids and date columns. We don't currently do any sort of user defined partition or sorting of the data to support other types of columns.
On your last question, no but be aware of the above and the fact that we don't currently distinguish empty string from null.