🚀 go-pugleaf

> Only to understand query speed with Procedure, If I
> 
> CREATE PROCEDURE Proc_1
> returns (   cod1 varchar(10),  cod2 smallint, cod3 smallint)
> as
> begin
>  for
>   Select cod1, cod2, cod3 from Tab1
>   where cod2>cod3
>   into:cod1, :cod2, :cod3
>   do    suspend  ;
> end
> 
> and I query it with
> 
> Select * from Proc_1
> where cod1 = 'test1'
> 
> a) Proc1 select only record matching the where clause of the query, or

The SP won't be able to use an index on cod1 in this case.

This is the main difference to a view regarding optimizing a WHERE clause.

> b) Proc1 retrives before all its records and after query select those 
> required  by its where condition ?

Yep.

> Following construct should be faster than previous ?

Yep, it should, if there is an index on cod1.

Check the execution plan of both statements and figure out if an index 
on cod1 will be used in both cases. ;-)


-- 
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com