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
1808
January 30, 2012 03:16AM
949
January 30, 2012 02:39AM
831
January 30, 2012 09:13AM
767
January 31, 2012 05:44AM
898
January 31, 2012 07:54AM
Re: running running running
965
January 31, 2012 03:10AM
933
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.