MySQL Forums
Forum List  »  Optimizer & Parser

Re: running running running
Posted by: paolo tome
Date: January 31, 2012 03:10AM

- The query seems to be fully equivalent (maintaining the left join and not inner join) !! The two queries give the same results !!

- {oj is an ODBC escape sequence to support outer joins (either left, right or full)
(I created the query with openoffice base)

- with deafult optimizer_search_depth setting (62) the 'original' query run indefinitely

- with optimizer_search_depth setting = 4 --> return results in 0.007 sec !!!!!!!!


Now what should I do? Can I set this variable, on the production server, with value = 4 (or = 0) or there are some disadvantages?

thanks so much, I'm very grateful to you

Paolo

Options: ReplyQuote


Subject
Views
Written By
Posted
2113
January 30, 2012 03:16AM
1164
January 30, 2012 02:39AM
981
January 30, 2012 09:13AM
939
January 31, 2012 05:44AM
1072
January 31, 2012 07:54AM
Re: running running running
1194
January 31, 2012 03:10AM
1150
January 31, 2012 05:00PM


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.