Query Performance Improvement

Question

Removing query from forums

Answer 1

We cannot say anything on this unless you provide some more details like table structures, index definitions, number of rows in each of the tables and in the resultset etc.

And also I don't like the CASE expression inside your ROW_NUMBER function. The query engine cannot identify any useful indexes (if any) for processing the query. A better way is to use dynamic SQL approch

The Curse and Blessings of Dynamic SQL (Erland's article)

---

Krishnakumar S

Answer 2

Issue resolved?

Regards
satheesh

Answer 3

not resolved.have took off the actual query.

Answer 4

Hi,

How forum users will be able to give you suggestions, unless you don't show your code or some posting your issue?

Regards
satheesh