| Subject | Re: [ib-support] slow left join on a view. |
|---|---|
| Author | Svein Erling Tysvaer |
| Post date | 2002-11-20T08:49:12Z |
Samy,
do you have an index on contacts.contact_code?
Set
At 12:20 19.11.2002 -0500, you wrote:
do you have an index on contacts.contact_code?
Set
At 12:20 19.11.2002 -0500, you wrote:
>PLAN JOIN (R NATURAL,JOIN (JOIN (JOIN (CV C NATURAL,CV CI INDEX
>(CITY_CITY_ID)),CV P INDEX (PRO_PROVINCE)),CV CO INDEX (COUNTRY_COUNTRY)))