MySQL Forums :: Newbie :: Optimization of where clause


Advanced Search

Optimization of where clause
Date: May 07, 2014 05:14AM

Regarding to optimization, do mysql optimization in query if first column in where clause is second column in index definition or is not in index definition ?

...where second_index_col operator val and first_index_col oper val etc...

Options: ReplyQuote


Subject Written By Posted
Optimization of where clause Grzegorz Brze╠Ęczyszczykiewicz 05/07/2014 05:14AM
Re: Optimization of where clause Grzegorz Brze╠Ęczyszczykiewicz 05/07/2014 05:27AM
Re: Optimization of where clause Rick James 05/08/2014 03:39PM


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.