assassinator
23rd March 2009, 09:43
Now I wonder which way would be efficiecier as follow:
1.
select tisfc001.mitm, tisfc001.osta, tisfc927.clot
from tisfc001, tisfc927
where tisfc001._index1 = {:tiitm926.pdno}
and tisfc927._index2 = {:tiitm926.pdno}
2.
select tisfc001.mitm, tisfc001.osta, tisfc927.clot
from tisfc001, tisfc927
where tisfc927._index2 = {:tiitm926.pdno}
and tiitm926.pdno refers to tisfc001
1.
select tisfc001.mitm, tisfc001.osta, tisfc927.clot
from tisfc001, tisfc927
where tisfc001._index1 = {:tiitm926.pdno}
and tisfc927._index2 = {:tiitm926.pdno}
2.
select tisfc001.mitm, tisfc001.osta, tisfc927.clot
from tisfc001, tisfc927
where tisfc927._index2 = {:tiitm926.pdno}
and tiitm926.pdno refers to tisfc001