SET NAMES NONE;

CREATE GENERATOR  SEQAMA;

CREATE TABLE AMA (
    NID             INTEGER NOT NULL,
    NFILEID         INTEGER,
    SSOURCE         VARCHAR( 1 ),
    SPAY            VARCHAR( 1 ),
    STEL_A          VARCHAR( 20 ),
    DBEGDATE        DATE,
    NDURATION       INTEGER,
    STEL_B          VARCHAR( 20 ),
    STYPE           VARCHAR( 1 ),
    SCAT_A          VARCHAR( 2 ),
    SINTRANC        VARCHAR( 6 ),
    NINCHANNEL      INTEGER,
    SOUTTRANC       VARCHAR( 6 ),
    NOUTCHANNEL     INTEGER,
    NOSSMINUTES     INTEGER,
    STYPEOSS        VARCHAR( 2 ),
    SOPERATOROSS    VARCHAR( 4 ),
    SMAPOSS         VARCHAR( 6 ),
    STYPETRAFFIC_A  VARCHAR( 1 ),
    STYPETRAFFIC_B  VARCHAR( 1 ),
    SMOBILEFLAG     VARCHAR( 1 ),
    SEDITFLAG       VARCHAR( 1 )
);

ALTER TABLE AMA ADD PRIMARY KEY (NID);


CREATE INDEX DBEGDATEX ON AMA (DBEGDATE);
CREATE INDEX TEL_AX ON AMA (STEL_A);
CREATE INDEX TEL_BX ON AMA (STEL_B);

SET TERM ^ ;

 /* Trigger: INSERT_AMA */ 
CREATE TRIGGER INSERT_AMA FOR AMA
ACTIVE BEFORE INSERT POSITION  0 
as
begin
   new.nid = gen_id( seqAMA, 1  );
end
^

SET TERM ; ^

SELECT first :nexts skip :ends * FROM ama 
 WHERE  (DBEGDATE between "29.08.2004 00:00:00" and "29.08.2004 23:59:59")
AND (NINCHANNEL between :chin11 and :chin12)
AND (NOUTCHANNEL between :chout11 and :chout12)
AND (SINTRANC=:sint)
AND (SOUTTRANC=:sout)
AND (
 (STEL_A Like "47392%") OR
 (STEL_A Like "47393%") OR
 (STEL_A Like "47394%") OR
 (STEL_A Like "47395%"))
AND (
 (STEL_B Like "32903%") OR
 (STEL_B Like "32904%") OR
 (STEL_B Like "32905%") OR
 (STEL_B Like "32906%"))
and (STYPETRAFFIC_A=:typetr1)
and (STYPETRAFFIC_B=:typetr2)
AND (NDURATION Like :duration11)
 ORDER BY DBEGDATE

Plan
PLAN (AMA INDEX (DBEGDATEX))

Adapted Plan
PLAN (AMA INDEX (DBEGDATEX))

 ------ Performance info ------ 
Prepare time = 40ms
Execute time = 17s 776ms
Current memory =  946   868 
Max memory =  982   288 
Memory buffers =  2   048 
Reads from disk to cache =  24   739 
Writes from cache to disk =  6 
Fetches from cache =  317   011 

ORDER BY DBEGDATE

PLAN (AMA INDEX (DBEGDATEX,TEL_BX,TEL_BX,TEL_BX,TEL_BX,TEL_AX,TEL_AX,TEL_AX,TEL_AX))

Plan
PLAN (AMA INDEX (DBEGDATEX,TEL_BX,TEL_BX,TEL_BX,TEL_BX,TEL_AX,TEL_AX,TEL_AX,TEL_AX))

Adapted Plan
PLAN (AMA INDEX (DBEGDATEX,TEL_BX,TEL_BX,TEL_BX,TEL_BX,TEL_AX,TEL_AX,TEL_AX,TEL_AX))

 ------ Performance info ------ 
Prepare time = 70ms
Execute time = 5s 718ms
Current memory =  953   392 
Max memory =  982   288 
Memory buffers =  2   048 
Reads from disk to cache =  1   842 
Writes from cache to disk =  6 
Fetches from cache =  2   047