Subject Re: [firebird-support] Advice requested on design pattern
Author Mike Ro
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.