Hi,

I have view with 100000 documets (records) diferent type. When I call
select * from view where type = some_type firebird made full view and
execute my sql statement. When I call sql statement without view just
join tables and put where type = some_type I get 20% faster respones
from database.

So how to write SP which will return data like it is described in
secound sample (without calling view), or someone have a better idea
how to increase speed of my db response?

Thanks in advanced...