Re: Стали возникать томоза при SELECT MA X(DATA) (fb 2.5.26082 и fb 2.5.25054)

Wed, 15 Sep 2010 11:40:01 -0700 

Вот полный скрипт.
/******************************************************************************/
/***               Generated by IBExpert 15.09.2010 22:33:06 
***/
/******************************************************************************/

/******************************************************************************/
/***      Following SET SQL DIALECT is just for the Database Comparer 
***/
/******************************************************************************/
SET SQL DIALECT 3;



/******************************************************************************/
/***                                 Tables 
***/
/******************************************************************************/


CREATE GENERATOR GLOBAL_ID;

CREATE TABLE KLIENT_ACCOUNT_PROVODKI (
    ID                   INTEGER NOT NULL,
    ID_ACCOUNT           T_BIG_INT NOT NULL /* T_BIG_INT = BIGINT */,
    ID_XXI               T_BIG_INT NOT NULL /* T_BIG_INT = BIGINT */,
    ID_XXI_0             T_BIG_INT /* T_BIG_INT = BIGINT */,
    DATA                 T_DATE /* T_DATE = DATE */,
    SUMMA                T_SUMMA NOT NULL /* T_SUMMA = NUMERIC(16,2) */,
    NO_DOC               T_INT /* T_INT = INTEGER */,
    NAZNACHENIE          A_1024 /* A_1024 = VARCHAR(1024) */,
    KONTRAGENT           T_A250 /* T_A250 = VARCHAR(250) */,
    BANK_KONTRAGENTA     T_A250 /* T_A250 = VARCHAR(250) */,
    KONTRAGENT_INN       T_A16 /* T_A16 = VARCHAR(16) */,
    KONTRAGENT_ACCOUNT   T_A32 /* T_A32 = VARCHAR(32) */,
    BIC_BANK_KONTRAGENT  T_A16 /* T_A16 = VARCHAR(16) */,
    DEL                  FIB$BOOLEAN DEFAULT 1 /* FIB$BOOLEAN = SMALLINT 
DEFAULT 1 NOT NULL CHECK(VALUE IN (0,1)) */,
    STATUS_PROVODKI      SMALLINT DEFAULT 4 NOT NULL,
    NO_PACHKA            T_INT /* T_INT = INTEGER */,
    KLIENT_NAME          T_A250 /* T_A250 = VARCHAR(250) */,
    KLIENT_INN           T_A16 /* T_A16 = VARCHAR(16) */,
    KLIENT_ACC           T_A20 /* T_A20 = VARCHAR(20) */
);




/******************************************************************************/
/***                           Unique Constraints 
***/
/******************************************************************************/

ALTER TABLE KLIENT_ACCOUNT_PROVODKI ADD CONSTRAINT 
UNQ1_KLIENT_ACCOUNT_PROVODKI UNIQUE (ID_ACCOUNT, ID_XXI, ID_XXI_0);


/******************************************************************************/
/***                              Primary Keys 
***/
/******************************************************************************/

ALTER TABLE KLIENT_ACCOUNT_PROVODKI ADD CONSTRAINT 
PK_KLIENT_ACCOUNT_PROVODKI PRIMARY KEY (ID);


/******************************************************************************/
/***                              Foreign Keys 
***/
/******************************************************************************/

ALTER TABLE KLIENT_ACCOUNT_PROVODKI ADD CONSTRAINT 
FK_KLIENT_ACCOUNT_PROVODKI_1 FOREIGN KEY (ID_ACCOUNT) REFERENCES 
KLIENT_ACCOUNT (ID) ON DELETE CASCADE ON UPDATE CASCADE;


/******************************************************************************/
/***                                Indices 
***/
/******************************************************************************/

CREATE INDEX KLIENT_ACCOUNT_PROVODKI_IDX2 ON KLIENT_ACCOUNT_PROVODKI 
(KONTRAGENT_INN);
CREATE DESCENDING INDEX KLIENT_ACCOUNT_PROVODKI_IDX_DAT ON 
KLIENT_ACCOUNT_PROVODKI (DATA);


/******************************************************************************/
/***                                Triggers 
***/
/******************************************************************************/



SET TERM ; ^

Ответить