MySQL Forums
Forum List  »  Optimizer & Parser

INDEX on DATE field and MONTH() YEAR() functions
Posted by: Tristan Crombez
Date: April 30, 2006 01:14PM


I was wondering if it is possible to create a table index on the MONTH(datefield) or YEAR(datefield) of a DATE type field.
Or does creating an index on a datefield also create an index on (year,month,day) of that datefield?
Or do I have to create 3 separate year, month, day fields and create an index on those instead of 1 date type field?


Options: ReplyQuote

Written By
INDEX on DATE field and MONTH() YEAR() functions
April 30, 2006 01:14PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.