MySQL Forums
Forum List  »  Optimizer & Parser

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

Hi,

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?

Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
INDEX on DATE field and MONTH() YEAR() functions
21273
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.