Hi [EMAIL PROTECTED] ! lG> Индексы вроде везде проставлены, а план lG> Natural и что самое обидное по самой lG> большой таблице :(
lG> PLAN (DOC INDEX (PK_DOC))(DET INDEX (DET_IDX2)) lG> JOIN (DET NATURAL,DOC INDEX (PK_DOC),OBJT INDEX lG> (PK_OBJECT), lG> ^^^^^^^^ lG> DS INDEX lG> (PK_TDOC_SUB,TDOC_SUB_IDX1,TDOC_SUB_IDX1), lG> TDOC INDEX (PK_TDOC),OBJF INDEX lG> (PK_OBJECT),TOVAR INDEX (PK_TOVAR)) Query ------------------------------------------------ select * from CARD_S(0) Plan ------------------------------------------------ PLAN (DOC INDEX (PK_DOC))(DET INDEX (DET_IDX2))JOIN (DS INDEX (PK_TDOC_SUB), DOC INDEX (DOC_IDX1), OBJF INDEX (PK_OBJECT), OBJT INDEX (PK_OBJECT), TDOC INDEX (PK_TDOC), DET INDEX (DET_IDX1), TOVAR INDEX (PK_TOVAR)) Adapted Plan ------------------------------------------------ PLAN (DOC INDEX (PK_DOC))(DET INDEX (DET_IDX2))JOIN (DS INDEX (PK_TDOC_SUB), DOC INDEX (DOC_IDX1), OBJF INDEX (PK_OBJECT), OBJT INDEX (PK_OBJECT), TDOC INDEX (PK_TDOC), DET INDEX (DET_IDX1), TOVAR INDEX (PK_TOVAR)) PS: FB 2.0.12654 CS --------------------- --~--~---------~--~----~------------~-------~--~----~ -~----------~----~----~----~------~----~------~--~---
