Home » RDBMS Server » Performance Tuning » help in tuning query
help in tuning query [message #344219] Fri, 29 August 2008 02:09 Go to next message
trupti111
Messages: 29
Registered: August 2008
Location: navi mumbai
Junior Member
Please help in tunng following two queries
table scan is full in both the queries

SELECT sr_no, agent_code, agent_name , report_to,
count(1) over() tc,
row_number() over(order by sr_no) rn
FROM AMS_LTS_LEAD_SUMMARY;


SELECT agent_id, first_name || ' ' || surname agent_name,
AMS_AGENT_MASTER.branch_code, branch_desc, designation,
reporting_to
FROM AMS_AGENT_MASTER, AMS_BRANCH_MASTER
WHERE AMS_AGENT_MASTER.branch_code = AMS_BRANCH_MASTER.branch_code
AND active IN ('A')
AND reporting_to IS NOT NULL
START WITH agent_id IN (SELECT agent_id
FROM AMS_AGENT_MASTER
WHERE reporting_to IS NULL)
CONNECT BY PRIOR agent_id = reporting_to;
Re: help in tuning query [message #344297 is a reply to message #344219] Fri, 29 August 2008 05:54 Go to previous message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can first read:
- OraFAQ Forum Guide, Performance Tuning section
- How to Identify Performance Problem and Bottleneck
- OraFAQ Performance Tuning
- Rosco's SQL Tuning Guide

Then provide the requested and usual information.

You can also have a look at Database Performance Tuning Guide.

Regards
Michel
Previous Topic: histogram
Next Topic: DB parameters
Goto Forum:
  


Current Time: Fri Dec 09 12:05:52 CST 2016

Total time taken to generate the page: 0.13283 seconds