Dynamic Where clause in XML

Question

Hi All,

I have a scenario in which i have to select an entity  based on where clauses which differs with user input. I am capturing the user input in  XML and processing it by checking each node and appending the corresponding where clause to main select statement(Dynamic SQL). This is taking a lot of time. How can we optimize it?

Thanks in Advance