MySQL Integer vs DateTime index

by

I see that in the test mentioned in the above answer, the author basically proves it that when the UNIX time is calculated in advance, INT wins.

More Related Contents:

  1. Is there any performance gain in indexing a boolean field?
  2. How to disable index in innodb
  3. How to debug Lock wait timeout exceeded on MySQL?
  4. How do I add indexes to MySQL tables?
  5. How to shrink/purge ibdata1 file in MySQL
  6. Is the primary key automatically indexed in MySQL?
  7. Mysql::Error: Specified key was too long; max key length is 1000 bytes
  8. How to see indexes for a database or table in MySQL?
  9. How to convert all tables from MyISAM into InnoDB?
  10. Speeding up row counting in MySQL
  11. MySQL varchar index length
  12. MySQL InnoDB foreign key between different databases
  13. Mysql Improve Search Performance with wildcards (%%)
  14. Force InnoDB to recheck foreign keys on a table/tables?
  15. How can I manipulate MySQL fulltext search relevance to make one field more ‘valuable’ than another?
  16. What is MySQL’s default ON DELETE behavior?
  17. DOs and DONTs for Indexes [closed]
  18. How do I repair an InnoDB table?
  19. How to enable INNODB in mysql
  20. Higher cardinality column first in an index when involving a range?
  21. How can I check MySQL engine type for a specific table?
  22. MySQL InnoDB: autoincrement non-primary key
  23. How do I rename a MySQL database (change schema name)?
  24. How to regex in a MySQL query
  25. Why doesn’t MySQL’s MyISAM engine support Foreign keys?
  26. MySQL optimizing INSERT speed being slowed down because of indices
  27. Would it help to add index to BIGINT column in MySQL?
  28. MySQL DROP all tables, ignoring foreign keys
  29. Mysql performance on 6 million row table
  30. How can I rebuild indexes and update stats in MySQL innoDB?

Leave a Comment