Matches not Work in 7.30
Hi,
I have IDS 7.30.UC2 on SCO Open server 3.2.5.0.2 and 7.30.UC3 with
Solaris 2.6
After switch to 7.30 from 5.08 discontinued work MATCHES.
Follow example witt sqlexplain output.
explain:
QUERY:
------
select * from ziv_sbj where obcvel matches "INFORMIX SOFTWARE S.R.O."
Estimated Cost: 5
Estimated # of Rows Returned: 1
1) zu6.ziv_sbj: INDEX PATH
(1) Index Keys: obcvel
Lower Index Filter: zu6.ziv_sbj.obcvel = 'INFORMIX SOFTWARE
S.R.O.'
QUERY:
------
select * from ziv_sbj where obcvel matches "INFORMIX*"
Estimated Cost: 59202
Estimated # of Rows Returned: 76387
1) zu6.ziv_sbj: SEQUENTIAL SCAN !!!!!!!!!
Filters: zu6.ziv_sbj.obcvel MATCHES 'INFORMIX*'
Table has 500 000 rows
create table "zu6".ziv_sbj
(
zivsbj integer not null ,
cissbj date,
prafor smallint not null ,
rocpod char(11),
jmepod char(15),
pripod char(20),
obcjme char(64),
obcvel char(64),
icopod char(9),
sbjsta char(16),
_stpins datetime year to minute not null ,
_usrins char(8) not null ,
_stpupd datetime year to minute,
_usrupd char(8),
_numver integer not null ,
_nxtrec integer,
primary key (zivsbj)
);
revoke all on "zu6".ziv_sbj from "public";
create index "zu6".i_ziv_sbj_1 on "zu6".ziv_sbj (rocpod,icopod);
create index "zu6".i_ziv_sbj_2 on "zu6".ziv_sbj (icopod,rocpod);
create index "zu6".i_ziv_sbj_3 on "zu6".ziv_sbj (obcjme);
create index "zu6".i_ziv_sbj_4 on "zu6".ziv_sbj (obcvel);
create index "zu6".i_ziv_sbj_6 on "zu6".ziv_sbj (pripod,jmepod);
thanks Petr