I'm sketching tables for event planner. All my event will have date and time, but the search will use only dates. The time will not be used for searching.
Will storing, searching, indexing rows using DATE be noticeably faster than using DATETIME format?
It's more convenient for me to store the event date and time in DATETIME type, but I'm more concerned about the speed.