MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: Optimising query with composite index, which says using where
Posted by: Rick James
Date: September 15, 2014 10:03AM

> it depends on rows returned from index to be in ROWID (primary key for InnoDB) order.

Thanks, Øystein, that helps me better understand when and how index merge works. (And why it is so rarely used.)

Timothy, another thing to check is key_buffer_size or innodb_buffer_pool_size.

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


Subject
Views
Written By
Posted
Optimising query with composite index, which says using where
1707
Timothy Mifsud
September 06, 2014 12:38AM
Re: Optimising query with composite index, which says using where
710
Timothy Mifsud
September 06, 2014 01:53AM
Re: Optimising query with composite index, which says using where
748
Rick James
September 07, 2014 10:46PM
Re: Optimising query with composite index, which says using where
723
Øystein Grøvlen
September 15, 2014 06:03AM
Re: Optimising query with composite index, which says using where
818
Rick James
September 15, 2014 10:03AM


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.