| Subject | Re: Firebird 2.1.3 optimizer in does not use index - Email found in subject |
|---|---|
| Author | Andreas Rulle |
| Post date | 2010-07-20T14:32Z |
Hello Milan,
yes, your advice results into the usage of the index on T1!
PLAN JOIN (T1 INDEX (IDX_T11), T2 INDEX (IDX_T12))
Greetings
Andreas
yes, your advice results into the usage of the index on T1!
> select t1.s1 from t1 left join t2 on t1.s1=t2.s1With the where clause FlameRobin reports
> WHERE T1.S1 = 1
>
> Now you get what you're expecting.
PLAN JOIN (T1 INDEX (IDX_T11), T2 INDEX (IDX_T12))
Greetings
Andreas