Re: running running running

[paolo tome]

- 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