Re: Optimizer Flaws in 7.23 - Simple example

Dianne Pendleton wrote: > > I don't think SET OPTIMIZATION FIRST_ROWS is available until 7.3. Can > someone verify this? I think that's what I heard at the conference. This is available in version 7.22 as follows: SET OPTIMIZATION [ALL_ROWS | FIRST_ROWS] You must set OPTCOMPIND=2 in order to switch on the optimiser. But.... (We must have a "but" to make it more plausable :-) to quote from the blurb: " This feature was developed using the "Siebel client benchmark" queries as test cases. This feature is initially provided in OnLine 7.22 and has been tested to address all the Siebel queries. Initially, this feature is only supported for a select number of VARs managed by ATG - Technology Partners. ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ There may be queries written that are not addressed in this initial offering. A fuller solution has been slated for 7.3. ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ " Hope that helps, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //| | +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+