Subject Is a joined query faster than a subquery, or doesn't it matter?
Author Jörg Schiemann

I've a master and a detail table like

create table "SampleMaster" (
MasterID integer not null primary key,
OrderNo integer not null,
Comment varchar(20),


create table "SampleDetail" (
DetailID integer not null primary key,
MasterID integer not null,
OrderPos integer not null,
quantity integer not null,
constraint fk_MasterID foreign key (MasterID) references SampleMaster

Is a query with a subquery faster then a joined query if I want all fields
from the SampleDetail and only OrderNo from SampleMaster?


Jörg Schiemann