Steve Berger
asked on
Tuning of SQL Query
Hi,
I have an SQL Query, it is taking more time to complete. I got TKPROF of that query and not able to find the exact issue there. I mean which table condition is over head for this issue. I have attached the TKPROF also.
Please advice me
Thanks
TKPROF.txt
I have an SQL Query, it is taking more time to complete. I got TKPROF of that query and not able to find the exact issue there. I mean which table condition is over head for this issue. I have attached the TKPROF also.
Please advice me
Thanks
TKPROF.txt
ASKER
please check the attachement. i posted with execution plan
yes iknow the exec plan for tkprof.
can you please just post the simple on from set autot on.
it has diferent info id ilke to look at.
can you please just post the simple on from set autot on.
it has diferent info id ilke to look at.
ASKER
Hi, I have posted here.
Query-Plan.xls
Query-Plan.xls
hi
whats bomping the query cost is acceesing
MTL_CATEGORIES_B table using MTL__CATEGORIES_B_N2 index
try and add a condition.
whats bomping the query cost is acceesing
MTL_CATEGORIES_B table using MTL__CATEGORIES_B_N2 index
try and add a condition.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
No Comments
could you please post the execution plan with query cost.