I have a Innodb table with a index that looks at 3 columns.
- ColA is integer and always has a value.
- ColB is varchar and always has a value.
- ColC is datetime and sometimes has a value (NULL).
My index appears to be looking at all records representing ColA,B,C (NULL or NOT NULL).
Is it possible to have the index only store ColC NULL values? This would shorten the index considerably (ie 27K to 1K).