|Subject||Re: [firebird-support] Advice requested on design pattern|
On 20/05/15 21:15, Alexandre Benson Smith iblist@... [firebird-support] wrote:
I am very sorry for my slow response, but thank you for explaining this.
In this way wouldn't the SP have the same problem that was mentioned by Louis, namely that only the index from the first table in the query would be used?
I did not read it in full details...
But the case of select on views be able to use the index on the first table I believe that's because of using of outer joins, with inner joins that would not be the case...
I don't know anything about how Firebird treats indexes in selectable SP, so I have some learning to do in this area.