OraFAQ Forum: SQL & PL/SQL » Need help in reducing the steps in query which is attached

Home » SQL & PL/SQL » SQL & PL/SQL » Need help in reducing the steps in query which is attached (PL_SQL DEVELOPER 9.0)

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

Need help in reducing the steps in query which is attached [message #577243]

Wed, 13 February 2013 12:33

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 6 times)

Report message to a moderator

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

mythrishree
Messages: 5
Registered: February 2013

Junior Member

THE FOLLOWING IS THE QUERY USED

Attachment: sample.csv
(Size: 20.97KB, Downloaded 6 times)

Report message to a moderator

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

joy_division
Messages: 4265
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.

Report message to a moderator

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

BlackSwan
Messages: 20086
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...

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 03:37:19 CDT 2013

Total time taken to generate the page: 0.12420 seconds