Home » SQL & PL/SQL » SQL & PL/SQL » Optimise Query (Oracle 8i)
Optimise Query [message #322864] Mon, 26 May 2008 08:33 Go to next message
rasi_85
Messages: 9
Registered: May 2008
Junior Member
Hi Friends,

I have converted five query into a single query,that single query displayed 65536 records.I have attached that query,please
anybody give reply to me.My problem is how can i optimise that query.

Regards
Rasi.
  • Attachment: arun.txt
    (Size: 5.62KB, Downloaded 165 times)
Re: Optimise Query [message #322866 is a reply to message #322864] Mon, 26 May 2008 08:36 Go to previous messageGo to next message
rasi_85
Messages: 9
Registered: May 2008
Junior Member
Because 65536 Records Displayed is my query.Data is repeated sir.what can i do?? anybody help. Embarassed
Re: Optimise Query [message #322877 is a reply to message #322864] Mon, 26 May 2008 09:50 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

>Data is repeated sir.what can i do??
SELECT DISTINCT

[Updated on: Mon, 26 May 2008 09:52] by Moderator

Report message to a moderator

Re: Optimise Query [message #322883 is a reply to message #322866] Mon, 26 May 2008 10:34 Go to previous message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
I always thought optimisation is used only for fine tuning the query and not to exclude the duplicates. Anyways just a quick glance have identified the following two tables are not joined.
Quote:

claim_survey_details
cnfgtr_parameter_table


Also, how about producing the output of Explain plan. It would have definitely highlighted you are doing a merge join cartesian.

Regards

Raj

[Updated on: Mon, 26 May 2008 10:35]

Report message to a moderator

Previous Topic: Selec not null colmn only
Next Topic: want SQL or PLSQL procedure to make a column as right justified (Merged)
Goto Forum:
  


Current Time: Mon Dec 05 05:14:02 CST 2016

Total time taken to generate the page: 0.23562 seconds