�������� � �������������

[Alexander Artukov]

úÁÐÒÏÓ, ÄÏ ÐÏÒÙ ÄÏ ×ÒÅÍÅÎÉ ÒÁÂÏÔÁ×ÛÉÊ ÎÏÒÍÁÌØÎÏ, ÎÁÞÁÌ ××ÏÄÉÔØ ÓÅÒ×ÅÒ ×
ÚÁÄÕÍÞÉ×ÏÓÔØ.

÷ÙÑÓÎÉÌÏÓØ, ÞÔÏ ×ÏÔ ÔÁËÏÊ ÚÁÐÒÏÓ Ó×ÁÌÉ×ÁÅÔÓÑ × natural

select  * from documents d, reg_value rv
where
  rv.doc = d.id and
  d.Pin in (2,42,61,82,83)

ðÌÁÎ
PLAN JOIN (RV NATURAL,D INDEX
(RDB$PRIMARY24,DOCUMENTS_PIN,DOCUMENTS_PIN,DOCUMENTS_PIN,DOCUMENTS_PIN,DOCUM
ENTS_PIN))

áÄÁÐÔÉÒÏ×ÁÎÎÙÊ ÐÌÁÎ
PLAN JOIN (RV NATURAL,D INDEX
(INTEG_75,DOCUMENTS_PIN,DOCUMENTS_PIN,DOCUMENTS_PIN,DOCUMENTS_PIN,DOCUMENTS_
PIN))

ïÐÙÔÎÙÍ ÐÕÔÅÍ ÕÄÁÌÏÓØ ÕÓÔÁÎÏ×ÉÔØ, ÞÔÏ ÄÏÂÁ×ÌÅÎÉÅ ÕÓÌÏ×ÉÊ ×ÙÐÒÁ×ÌÑÅÔ
ÓÉÔÕÁÃÉÀ:

select  * from documents d, reg_value rv
where
  rv.doc = d.id and
  d.Pin in (2,42,61,82,83) and d.pin >=2 and d.Pin<=83

ðÌÁÎ
PLAN JOIN (D INDEX
(DOCUMENTS_PIN,DOCUMENTS_PIN,DOCUMENTS_PIN,DOCUMENTS_PIN,DOCUMENTS_PIN,DOCUM
ENTS_PIN),RV INDEX (REG_VALUE_DOC))

áÄÁÐÔÉÒÏ×ÁÎÎÙÊ ÐÌÁÎ
PLAN JOIN (D INDEX
(DOCUMENTS_PIN,DOCUMENTS_PIN,DOCUMENTS_PIN,DOCUMENTS_PIN,DOCUMENTS_PIN,DOCUM
ENTS_PIN),RV INDEX (REG_VALUE_DOC))


îÅÕÀÔÎÏ, ÏÄÎÁËÏ - ÐÏÔÏÍÕ ËÁË ÎÅÐÏÎÑÔÎÏ, ÐÏ ËÁËÏÊ ÐÒÉÞÉÎÅ ÏÐÔÉÍÉÚÁÔÏÒ ÔÁË
ÓÅÂÑ ×ÅÄÅÔ.

üËÓÐÅÒÉÍÅÎÔÙ ÐÒÏ×ÏÄÉÌÉÓØ ÎÁ Ä×ÕÈ ÒÁÚÎÙÈ Ó×ÅÖÅÏÔÒÅÓÔÏÒÅÎÎÙÈ ÂÁÚÁÈ. îÁ âáúå_1
ÚÁÐÒÏÓ ÉÄÅÔ ÎÁÔÕÒÁÌÏÍ, ÎÁ âáúå_2 - ÉÓÐÏÌØÚÕÅÔ ÉÎÄÅËÓÙ.

åÓÔØ ÍÙÓÌÉ, ÍÏÖÅÔÅ ÐÏÄÅÌÉÔØÓÑ?

äÏÐÏÌÎÉÔÅÌØÎÁÑ ÉÎÆÏÒÍÁÃÉÑ - ÏÔÄÅÌØÎÙÍ ÓÏÏÂÝÅÎÉÅÍ ÎÉÖÅ