Subject | performance question |
---|---|
Author | hundri_106@hotmail.com |
Post date | 2001-11-17T16:27:05Z |
Which should be used to get the best performance when using these
similar queries:
for
select a.ID_Link, b.Title
from table1 a, table2 b
where a.ID_Link = b.ID
into :x, :y
do ...
OR
for
select a.ID_Link
from table1 A
into :x do
begin
select b.Title
from table2 B
where b.ID = :x
into :y
end
Just curious,
Hundri
similar queries:
for
select a.ID_Link, b.Title
from table1 a, table2 b
where a.ID_Link = b.ID
into :x, :y
do ...
OR
for
select a.ID_Link
from table1 A
into :x do
begin
select b.Title
from table2 B
where b.ID = :x
into :y
end
Just curious,
Hundri