MySQL – Should you put an index on a Boolean field to help query performance?
I am often asked if it makes sense to place an index on a Boolean field in order to improve query performance. In general, because a boolean value can only…
Read moreMySQL – DateTime vs. TimeStamp – When to use?
This question often comes up, and while there is often a heated debate, these are my thoughts on the subject. I typically use a timestamp when I need to record…
Read moreMySQL – Constraints on Hierarchical Data in a Self-Referential Table
I recently had a client who was using a table structure that utilized a self-referential structure using an ID field and Parent_ID fields. After upgrading to Innodb, his DBA was…
Read moreMySQL Foreign Key Night-mare
I recently was working with a 3rd party DB that was designed well and used lots of foreign keys to enforce referential integrity. Unfortunately, the application that used the DB…
Read more