Hello, I have a little performance problem and could resolve it if I could add the restriction in the where clause to the join clause. Actual the generated sql looks like:
select * from parent p left outer join child c on c.Parent = p.Id where p.Name like '%theName%' or c.Name like '%theName%' This is to slow. But if I could generate a statement like select * from parent p left outer join child c on c.Parent = p.Id and c.Name like '%theName%' where p.Name like '%theName%' it would be much faster. Is there a way to realize this? Regards Armin -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
