MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: Does MySQL support function based index on datetime column?
Posted by: KimSeong Loh
Date: September 06, 2007 06:25PM

MySQL cannot use functions index.

DESC is not a good way to show what index you have.
Use SHOW CREATE TABLE instead.

A composite index on (from_system,event_time) may help a little bit, but still won't help the YYYYMM issue.

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


Subject
Views
Written By
Posted
Does MySQL support function based index on datetime column?
13987
Sailesh Patel
September 06, 2007 03:34PM
Re: Does MySQL support function based index on datetime column?
6971
KimSeong Loh
September 06, 2007 06:25PM
Re: Does MySQL support function based index on datetime column?
5559
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.