kowsika devi
asked on
Query optimization
Execution plan doubts.
Query is running so long time can any one pl say how can i check am attaching my execution plan file and my function file also.
Execution-plan-Slow-running-quer.sqlplan
Loln_fn_allprint_disbursementdet.sql
Query is running so long time can any one pl say how can i check am attaching my execution plan file and my function file also.
Execution-plan-Slow-running-quer.sqlplan
Loln_fn_allprint_disbursementdet.sql
If you can remove the DISTINCT from the queries then it will help to improve the performance.
ASKER
but i need with out duplicates victor jj.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Solution provided.