--- In firebird-support@yahoogroups.com, "nikicab_1999"
<nikicab_1999@y...> wrote:

>
> If I have a view (MyView) like
> SELECT myBlob_id, myBlob from MyTable
>
> and do SELECT * FROM MyView WHERE MyBlob_id=:id
>
> will there be any performance penalty i.e. will FB select all blobs
> from MyTable first and then filter it out to give me just one record
> OR will it give me the record right away?
>
> Thanks,
> Nick
>

Views generally use the same plan as the underlying queries.

So providing MyBlob_id is indexed, it will fetch the correct record
right away. Primary keys and foreign keys are indexed by default.

Adam