MySQL Forums
Forum List  »  Optimizer & Parser

Re: Index for Query
Posted by: dileep ch
Date: July 18, 2012 11:52PM

Hi,

The changes you preferred
INDEX(event_id, jail_broken, param4, param5, param6, cdate) -- with cdate _last_
INDEX(event_id, param4, param5) -- in any order.

And any other are not using to optimize.

Can you say me a very good book about indexing with many examples.
Our manual dont have many examples.

Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
2921
July 17, 2012 12:41AM
1449
July 17, 2012 10:36PM
Re: Index for Query
1429
July 18, 2012 11:52PM
2109
July 19, 2012 09:49PM


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.