I have a test table like this -
create table test_table(name varchar(32), id integer);
where id field is primary key

and I have a simple SP -
create procedure test_sp()
returns(name varchar(32), id integer)
as
begin
for select name, id from test_table into :name, :id
do suspend;
end

Question -
if I will execute my SP with query
select * from test_sp() order by id

Will SP use indexes?

--
chand0s.lazy.inbox@...


[Non-text portions of this message have been removed]