Hi,
I can't see much problems in queries.
Can you send EXPLAIN_PLAN of both the queries?
Also, did you check the buffers gets in both queries such as physical reads, logical buffers, consistent gets etc.
Thanks,
|
Results 1 to 5 of 5
Thread: How to Fine Tune This SQL QueryThreaded View
|
Click Here to Expand Forum to Full Width |