Home » SQL & PL/SQL » SQL & PL/SQL » Need help in reducing the steps in query which is attached (PL_SQL DEVELOPER 9.0)
Need help in reducing the steps in query which is attached [message #577243] Wed, 13 February 2013 12:33 Go to next message
mythrishree
Messages: 5
Registered: February 2013
Junior Member
Hi Everyone,

THANKS FOR POSTING THE REPLIES FOR MY LAST THREAD. THAT REALLY HELPED. I CAME BACK AGAIN BECAUSE I NEED HELP FROM THIS FORUM IN REDUING THE LENGTH OF MY QUERY WHICH I HAD GIVEN IN THE ATTACHED CSV FILE. I HAD ALSO PLACED SAMPLE DATA ALONG WITH THE QUERY. I HOPE IT WILL BE UNDERSTANDABLE. THE QUERY WHICH I WROTE IS TOO LONG AND TAKING HOURS TOGETHER TO RUN AND DISPLAY RESULT. IT WOULD BE A GREAT FAVOUR TO ME IF ANYONE CAN REDUCE THE LINES IN MY QUERY AND MAKE IT RUN FAST....PLEASE I WAS NOT KNOWING THE WAY HOW TO MAKE IT SHORT. IT HAS MANY LOGICS IN IT... Confused


THANKS IN ADVANCE FOR SPARING YOUR TIME IN UNDERSTANDING MY PROVLEM....

REGARDS,
MYTHRI.
  • Attachment: SAMPLE1.csv
    (Size: 16.24KB, Downloaded 21 times)
Re: Need help in reducing the steps in query which is attached [message #577244 is a reply to message #577243] Wed, 13 February 2013 12:39 Go to previous messageGo to next message
mythrishree
Messages: 5
Registered: February 2013
Junior Member
THE FOLLOWING IS THE QUERY USED
  • Attachment: sample.csv
    (Size: 20.97KB, Downloaded 22 times)
Re: Need help in reducing the steps in query which is attached [message #577245 is a reply to message #577244] Wed, 13 February 2013 12:45 Go to previous messageGo to next message
joy_division
Messages: 4515
Registered: February 2005
Location: East Coast USA
Senior Member
Why did you now post this right in the message? I for one will not open nor download attachments.
Re: Need help in reducing the steps in query which is attached [message #577246 is a reply to message #577245] Wed, 13 February 2013 12:50 Go to previous message
BlackSwan
Messages: 22792
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

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

mythrishree wrote on Tue, 05 February 2013 19:57
Thanks everyone for the time spent in answering my question. I was very vague at my questioning.Sorry for that.I will not do it the next time.Sorry... Smile


is not this new thread, your "next time"?

[Updated on: Wed, 13 February 2013 12:52]

Report message to a moderator

Previous Topic: logic to check record exist in tabl
Next Topic: How to commit for every 10000 records in execute immediate.
Goto Forum:
  


Current Time: Sat Sep 20 17:31:12 CDT 2014

Total time taken to generate the page: 0.07320 seconds