| Subject | Re: slow left join on a view. |
|---|---|
| Author | Samy Song |
| Post date | 2002-11-21T16:43:09Z |
Yes I do. unique.
--- In ib-support@y..., Svein Erling Tysvaer
<svein.erling.tysvaer@k...> wrote:
--- In ib-support@y..., Svein Erling Tysvaer
<svein.erling.tysvaer@k...> wrote:
> Samy,(COUNTRY_COUNTRY)))
> 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