Hello,

Using D5.1
IBO 4.2.Ib

I have table dn_header with this struc


CREATE TABLE DN_HEADER
(
DN_HEADER_ID NUMERIC( 4, 0) NOT NULL,
NOMOR D_VARCHAR_10 COLLATE NONE,
TANGGAL DATE,
SJV D_VARCHAR_30 COLLATE NONE,
NO_REV SMALLINT,
BALANCE D_NUM_17_2 ,
REFF_AKTIF_CODE D_BOOLEAN DEFAULT 'N' COLLATE NONE,
POSTED_CODE D_POSTED DEFAULT 'U' COLLATE NONE,
PRINT SMALLINT,
REVISED_CODE D_BOOLEAN DEFAULT 'N' COLLATE NONE,
SAY_WORDS D_MEMO ,
CONTACTS_ID INTEGER,
RSN_SJV D_VARCHAR_50 COLLATE NONE,
RSN_REV D_VARCHAR_50 COLLATE NONE,
RSN_CCL D_VARCHAR_50 COLLATE NONE,
INSERT_BY VARCHAR( 10) CHARACTER SET NONE DEFAULT USER
COLLATE NONE,
INSERT_TIME TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
DATE_CCL TIMESTAMP,
CURR_ID SMALLINT DEFAULT 0,
BLANK_SJV D_BOOLEAN DEFAULT 'N' COLLATE NONE,
BALANCE_ORIG NUMERIC( 17, 2),
MARKETING_ID INTEGER
);

and this indexes


CREATE ASC INDEX DN_HEADER_NOMOR ON DN_HEADER (NOMOR, NO_REV);

CREATE ASC INDEX DN_HEADER_POSTED_CODE ON DN_HEADER (POSTED_CODE);

CREATE ASC INDEX DN_HEADER_REFF_AKTIF_CODE ON DN_HEADER (REFF_AKTIF_CODE);

CREATE ASC INDEX DN_HEADER_SJV ON DN_HEADER (SJV);

CREATE ASC INDEX DN_HEADER_TANGGAL ON DN_HEADER (TANGGAL);


primary key info

ALTER TABLE DN_HEADER ADD CONSTRAINT PK_DN_HEADER PRIMARY KEY
(DN_HEADER_ID, DN_HEADER_ID);


I just try simple query on my program like

Select * from dn_Header
where nomor like '1234'

and here from the monitor
/*---
PREPARE STATEMENT
TR_HANDLE = 14435720
STMT_HANDLE = 14441340

Select * from dn_Header
where nomor like ? /* test */

PLAN (DN_HEADER NATURAL)

SECONDS = 0.030
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14435720
STMT_HANDLE = 14441340
PARAMS = [ Version 1 SQLd 1 SQLn 1
[TEST] = '1234' ]
----*/

Then i execute from IB Workbench or EMS QuickDesk

the plan resulted is

PLAN (DN_HEADER INDEX (DN_HEADER_NOMOR))


Why query with like options in my program not using dn_header_nomor indexes
?

May be i miss something ?

Any addvice will be appreciated.

Thanks and regards