Subject | Does SP use indexes? |
---|---|
Author | chand0s |
Post date | 2006-07-28T23:39:29Z |
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]
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]