Re: MATCHES problem
Im Artikel <01bc00a2$ee4a9b20$6595ccc2@ppp>, "ACE"
<szepczynski@hotmail.com> schreibt:
>I've encountered a serious error of INFORMIX-ONLINE v. 7.1x, 7.2x
>on following platforms:
> DYNIX/ptx, SCO UNIX, AIX, DEC OSF UNIX, IRIX, Solaris and HP/UX.
> Construction:
>select tabid from systables where tabname matches 'sys*'
> shows with EXPLAIN ON: SEQUENTIAL SCAN>
>select tabid from systables where tabname[1,3]='sys'
> shows INDEX SCAN
>(Indexes are not used even one use simple 'matches' phrase).>This error doesn't occur in versions 5.x of ONLINE.
>Think about table with over 2,000,000 records.
>On SEQUENT (Dynix/ptx) bug was corrected by setting OPTCOMPIND to 0. But
>this fix doesn't work on another platforms.
>Does anybody know how to fix this bug on another platforms?
> ACE
>
>
run 'update statistics medium;', then try it again;
ciao volker