| Subject | Re: [ib-support] Indexes and Joins |
|---|---|
| Author | Svein Erling Tysvær |
| Post date | 2002-04-04T09:41:31Z |
Sorry,
the plan I just wrote will not work. You have to move BT up above CL, i.e.
PLAN
SORT
(JOIN
(JOIN
(SO INDEX (SERVICEORDER_STATUS_INVOICENUMBER_DATECOMPLETED),
BT INDEX (CLIENTBILLTO_CLIENTBILLTOID),
CL INDEX (RDB$PRIMARY13)
),
PD INDEX (PARTDETAIL_SO)
)
)
Set
the plan I just wrote will not work. You have to move BT up above CL, i.e.
PLAN
SORT
(JOIN
(JOIN
(SO INDEX (SERVICEORDER_STATUS_INVOICENUMBER_DATECOMPLETED),
BT INDEX (CLIENTBILLTO_CLIENTBILLTOID),
CL INDEX (RDB$PRIMARY13)
),
PD INDEX (PARTDETAIL_SO)
)
)
Set