Re: ONLINE V7.20 : Query Optimizer :BIG PROBLEM With LIKE 'AA%'
I saw the same problem in INFORMIX-OnLine Version 7.23.UC1 export OPTCOMPIND=0 Yes, if you are using 4gl, but if you have INFORMIX New Era onmonitor Parameters pdQ Optimizer Hint = 0 You have to Take-Offline the INFORMIX Ivan Velasquez }From ilist@rmy.emory.edu Sat Oct 18 16:12:05 1997 }Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1) id RAA16834 for informix-list-out; Sat, 18 Oct 1997 17:30:01 -0400 (EDT) }From: stefan <stefan@weideneder.de> }Message-Id: <34491B70.1B97F9D0@weideneder.de> }Subject: Re: ONLINE V7.20 : Query Optimizer :BIG PROBLEM With LIKE 'AA%' }Date: Sat, 18 Oct 1997 19:26:24 -0100 }Reply-To: stefan <stefan@weideneder.de> }Organization: SEB WEIDENEDER }Sender: informix-list-owner@rmy.emory.edu }To: informix-list@rmy.emory.edu }X-Informix-List-Id: <news.44158> } }Carlos Costa e Silva wrote: }> }> No indexes ? }> }> sqexplain.out: }> }> QUERY: }> ------ }> select number,name }> from persons }> where name like 'Alex%' }> }> Estimated Cost: 2 }> Estimated # of Rows Returned: 4 }> }> 1) persons: INDEX PATH }> }> (1) Index Keys: name person_type number (Key-Only) }> Lower Index Filter: persons.name LIKE 'Alex%' }> }> > -----Original Message----- }SNIP }> > other table...). }> > }> > I have try value 0 or 2 for OPTCOMPIND. }> > I have use UPDATE STATISTICS ...... }> > } }Just to be sure ... } }export OPTCOMPIND=0 } }> > To test this just type under DBaccess: }> > create database test ; }> > create table x (y integer,x char(20)); }> > create index x on x(x); } }And do not forget: } } UPDATE STATISTICS FOR TABLE x; } }> > set explain on; }> > select * from x where x like "aa%"; }> > you will see the result. }> > Nota: if there is only one field in the table, it works correctly! }> > }> > Is there Anyone who can help me? }> > thanks }> > }> > -- }> > Georges SCHNEIDER }> > Incotec Inc. }> > }> > incotec@incotec.fr } } }Stefan } ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com