ODP: [firebird-support] Question about index use

[Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]]

Are you sure that this query looks like this?

For me such query use indexes in both cases left and inner.
Show full example with plans

Regards,
Karol Bieniaszewski

[firebird-support] Question about index use

[Carsten Schäfer ca_schae...@gmx.de [firebird-support]]

Hi,

I'm using FB 3.0.4 on Windows and i'm asking why the index (on 
field_B)is not used in the follwing query?


Select * from table_A a left join table_B b on a.field_A = b.field_A 
where b.field_B = 1;


field_A is a standard foreign key and field_B is an indexed field but 
the index is not used and so the query is slow (for big tabels).


When i use an inner join the index on field_B is used, but i don't get 
why FB has to make a difference in this case.


In this case the result set should always be the same, regardless of 
inner join or left join, or not?


Regards
Carsten

[firebird-support] Question about index use

[Carsten Schäfer ca_schae...@gmx.de [firebird-support]]

Hi,

I'm using FB 3.0.4 on Windows and i'm asking why the index (on 
field_B)is not used in the follwing query?


Select * from table_A a left join table_B b on a.field_A = b.field_A 
where b.field_B = 1;


field_A is a standard foreign key and field_B is an indexed field but 
the index is not used and so the query is slow (for big tabels).


When i use an inner join the index on field_B is used, but i don't get 
why FB has to make a difference in this case.


The result set should always be the same, regardless of inner join or 
left join, or not?


Regards
Carsten