Hi All

i have procedure contain this statement

for
select .....
into .....
do
begin
......
end

it take about 3s to execute

i had to add order by Field

for
select .....
order by Field
into .....
do
begin
....
end

it take about 6s to execute

although this field is Indexed and the optimizer uses this index
(no sort was performed)

i need to know where this time goes in if possible how to sppeed up
this statement

my regards to all
belal al-hamed