OraFAQ Forum: Performance Tuning » Long Running Query

Home » RDBMS Server » Performance Tuning » Long Running Query (Oracle 9,Unix)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Long Running Query [message #490882]

Fri, 28 January 2011 00:32

gurukrishnan
Messages: 1
Registered: January 2011
Location: Chennai

Junior Member

Hi folks,

We have a long running query. Its taking more than half hour to fetch records. so could pls help me out on this.....

Query:
SELECT *
FROM TableA,
TableB,
TableC,
TableD
WHERE TableB.KEY_ID(+) = TableA.KEY_ID
AND TableB.SOURCE_ID(+) = TableA.SOURCE_ID
AND TableC.KEY_ID(+) = TO_CHAR (TableA.LINE_ID)
AND TableC.SOURCE_ID(+) = TableA.SOURCE_ID
AND TableD.KEY_ID(+) = TO_CHAR (TableA.LINE_ID)
AND TableD.SOURCE_ID(+) = TableA.SOURCE_ID

Note:TableA doesnt have any index.We dnt have any rights to create index

Report message to a moderator

Re: Long Running Query [message #490883 is a reply to message #490882]

Fri, 28 January 2011 00:36

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Since NOBODY can optimize SQL just by looking at it, we need a few more details.
http://www.orafaq.com/forum/m/433888/136107/#msg_433888
Please refer to URL above & be sure to provide the details requested:
1) DDL for all tables & indexes
2) EXPLAIN PLAN
3) output from SQL_TRACE & tkprof

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Previous Topic:	Create Index vs Rebuild Index
Next Topic:	Using a stats table instead of regular stats to get a plan

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 20 17:17:23 CST 2025