description: Hi,

There is a very large table. When the table is queried, if the parameters carried are not assigned, the query is very slow.
Example:

=>

Hi,

There is a very large table(10 million records ). When the table is queried, if the parameters carried are not assigned, the query is very slow.
Example:

CREATE TABLE WORKBILL (
BEDID INTEGER,
GRPID INTEGER,
WORKINGORDER SMALLINT NOT NULL,
WBNO VARCHAR(15) NOT NULL,
EMPLOYEEID INTEGER,
QUANTITY SMALLINT DEFAULT 1 NOT NULL,
BADPIECES SMALLINT DEFAULT 0 NOT NULL,
OPENDATE DATE DEFAULT 'NOW',
CLOSEDATE DATE,
QSCALE DOUBLE RPECISION,
USERID INTEGER,
WDEPARTID INTEGER DEFAULT -1 NOT NULL,
UPDATETIME TIMESTAMP,
ISADJUST INTEGER,
TIMELONG INTEGER,
PRIMARY KEY(BEDID)
);

CREATE INDEX WORKBILL_IDX1 ON WORKBILL (CLOSEDATE);

--------------------------
USE IBExpert OR FireDac FDQUERY

SELECT * FROM WORKBILL WHERE CLOSEDATE BETWEEN :BEGINDATE AND :ENDDATE ;

if the parameters carried are not assigned, the query is very slow. result empty