if i have a table structure like this :
Code:
create table part(id number primary key, name varchar2(25));
create table product(id number primary key, name varchar2(25));
create table product_parts(id number, product_id number, part_id number, primary key(id, product_id, part_id), foreign key(part_id) references part(id), foreign key(product_id) references product(id);
My questions are :
1.)if i add a field to product_parts ( which is a join table ) does it affect the selection ? ( meaning can it cause n+1 select issues ? )
2.) How can create a criteria to load products from Product_Parts class without causing any n+1 selects.
Any kind of insight would be helpful.
Login
FAQ
Search
