Home » SQL & PL/SQL » SQL & PL/SQL » Pls Help!
Pls Help! [message #441919] Wed, 03 February 2010 22:55 Go to next message
Sowdhaminya
Messages: 1
Registered: February 2010
Junior Member
Hi....

I am executing a query in SQL developer which takes about 22 minutes. It is just a select query with joins which will search about 600000 records... Please help me how to reduce the execution time of my query..

Re: Pls Help! [message #441930 is a reply to message #441919] Wed, 03 February 2010 23:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.orafaq.com/forum/mv/msg/84315/433888/102589/#msg_433888

Regards
Michel
Re: Pls Help! [message #441931 is a reply to message #441919] Wed, 03 February 2010 23:33 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
Sowdhaminya wrote on Wed, 03 February 2010 20:55
Hi....

I am executing a query in SQL developer which takes about 22 minutes. It is just a select query with joins which will search about 600000 records... Please help me how to reduce the execution time of my query..



Please REALIZE we can NOT optimize what we can't see!

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

Post Operating System (OS) name & version for DB server system.
Post results of
SELECT * from v$version
Re: Pls Help! [message #441942 is a reply to message #441931] Thu, 04 February 2010 00:07 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
BlackSwan wrote on Wed, 03 February 2010 23:33

Please REALIZE we can NOT optimize what we can't see!


Laughing So True
Re: Pls Help! [message #442058 is a reply to message #441919] Thu, 04 February 2010 10:25 Go to previous messageGo to next message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
Here is the optimized solution.
Re: Pls Help! [message #442101 is a reply to message #442058] Thu, 04 February 2010 12:34 Go to previous message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Kevin Meade wrote on Thu, 04 February 2010 11:25
Here is the optimized solution.


Good one Kevin!
Previous Topic: Table/User Information
Next Topic: sql passing arguments special characters problem
Goto Forum:
  


Current Time: Sun Dec 04 22:46:36 CST 2016

Total time taken to generate the page: 0.17267 seconds