Yes, that is correct. In order to index I use a tinyint and set the constraints to 0 or 1. Is using the tinyint data-type this way the best way to represent this, or is there a better data-type that I could use (remember though I want to have an index on it.)