> No it should only return 1 line but even with “and jtype = j.jtype” added to > the subselect condition it still takes almost 5 minutes to return data
Please provide the PLAN for the statement and the details of indexes defined for the queries tables. Sean
