On 20/5/2015 16:03, Mike Ro miker...@gmail.com [firebird-support] wrote:
Thank you for your response.
On 20/05/15 11:25, Alan J Davies alan.dav...@aldis-systems.co.uk
[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.
http://www.avast.com