MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: Does MySQL support function based index on datetime column?
Posted by: Benjamin Fonze
Date: November 20, 2007 06:07PM

The way I would do it would be by adding a new field to your table, integer, and run a big update to set YYYYMM values in that field.

Then you can index it and use it for all your queries.

Tricky but should help a lot your queries.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Does MySQL support function based index on datetime column?
13981
Sailesh Patel
September 06, 2007 03:34PM
Re: Does MySQL support function based index on datetime column?
6970
KimSeong Loh
September 06, 2007 06:25PM
Re: Does MySQL support function based index on datetime column?
5558
Benjamin Fonze
November 20, 2007 06:07PM


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.