I wanted to know best use of queries in customization for good database performance.
Suppose I am using the below statement
womboset.setWhere("WORKORDER.WONUM in (select wonum from allocation where personid = '"personid"') " +
"AND WORKORDER.CLASSSTRUCTUREID in (select classstructureid from classancestor where ancestorclassid = 'PNLMOVE')" );
should i use that way or some other for good database performance.
Plz clarify my doubts.
This topic has been locked.