Subject Re: [firebird-support] Advice requested on design pattern
Author Alexandre Benson Smith
On 20/5/2015 16:03, Mike Ro miker169@... [firebird-support] wrote:
Thank you for your response.

On 20/05/15 11:25, Alan J Davies Alan.Davies@... [firebird-support] wrote:

Another way of doing what you want would be to use SPs instead of Views.
Then if you "select * from SP" and hide it as below, no-one can see what
you are doing with the data.

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?

Sorry if I misunderstood or my knowledge of SP is lacking.

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...

see you !

Este email está limpo de vírus e malwares porque a proteção do avast! Antivírus está ativa.