14.09.2010 19:27, Костюковский Олег пишет:
Plan: -------------------------------------------------------------------------------- (KLIENT_ACCOUNT_PROVODKI ORDER UNQ1_KLIENT_ACCOUNT_PROVODKI INDEX (FK_KLIENT_ACCOUNT_PROVODKI_1))
Не вижу ниже вот этого индекса: UNQ1_KLIENT_ACCOUNT_PROVODKI.
На текущий момент на таблицу KLIENT_ACCOUNT_PROVODKI имеются следующие индексы(добавлял удалял) ALTER TABLE KLIENT_ACCOUNT_PROVODKI ADD CONSTRAINT PK_KLIENT_ACCOUNT_PROVODKI PRIMARY KEY (ID); 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; CREATE DESCENDING INDEX KLIENT_ACCOUNT_PROVODKI_IDX1 ON KLIENT_ACCOUNT_PROVODKI (DATA, ID_ACCOUNT); CREATE INDEX KLIENT_ACCOUNT_PROVODKI_IDX2 ON KLIENT_ACCOUNT_PROVODKI (KONTRAGENT_INN); CREATE INDEX KLIENT_ACCOUNT_PROVODKI_IDX3 ON KLIENT_ACCOUNT_PROVODKI (DATA); CREATE DESCENDING INDEX KLIENT_ACCOUNT_PROVODKI_IDX_DAT ON KLIENT_ACCOUNT_PROVODKI (DATA);
-- Дмитрий Еманов
