[Firebird-devel] Can newer FB use index in updates with where on fk?

2011-08-29 Thread Kjell Rilbe
Hi, In FB 2.1 I find it frustrating that FB can't use the FK index in queries like this: update Child set Something = 'New stuff' where MasterId in ( select Id from Master where OtherThing = 'SoughtValue' ) I know this can be constructed in a few other ways, e.g. using an

Re: [Firebird-devel] Can newer FB use index in updates with where on fk?

2011-08-29 Thread Dmitry Yemanov
30.08.2011 0:44, Kjell Rilbe wrote: Has this been improved since FB 2.1? Nope. Any future plans? In FB3, perhaps. Dmitry -- Special Offer -- Download ArcSight Logger for FREE! Finally, a world-class log management