You are currently viewing the MySQL section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Im wondering if a datetime field be indexed to improve my application's performance when comparing fetching rows based on date attributes. Like I want to fetch all rows that are older by a particular date and have them sorted by date.
Yes, I have done alot of times.
I even used this index to populate a default integer value
in a field and a username. This way I would know how many
times a user has transact a table/database.
Hope this helps.