When we need to store boolean fields in the database, which is better? true and null or true and false combination.
I have seen many article which says to use true and false. Some reports say true and null combinations provide better performance.
I am designing a website with Ruby on Rails and mariadb. I need to add a boolean status field to a table with 1 million rows.
The purpose of this status field is for filtering and reports.