Home » Developer & Programmer » Reports & Discoverer » when fetching data from database its take too much time and display in reports,?
when fetching data from database its take too much time and display in reports,? [message #258107] Fri, 10 August 2007 04:49 Go to next message
jeeva07
Messages: 7
Registered: June 2007
Junior Member
SELECT ALL MRS_DTL.PROD_CODE, item_master.item_name,
MRS_DTL.QTY_REQD, MRS_DTL.QTY_ISSUED, MRS_DTL.QTY_RET, MRS_DTL.MRS_DATE, MRS_DTL.MRS_NO, MRS_DTL.SL_NO, MRS_HDR.WO_NO, MRS_HDR.WO_DATE
FROM MRS_HDR, MRS_DTL,item_master
WHERE (MRS_DTL.MRS_NO = MRS_HDR.MRS_NO)
and (item_master.item_code=mrs_dtl.prod_code)
and MRS_DTL.PROD_CODE like:P_itemname


is it correct or we have to in diff?
Re: when fetching data from database its take too much time and display in reports,? [message #258131 is a reply to message #258107] Fri, 10 August 2007 06:24 Go to previous message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Topic title suggests that query takes much time when executed in a report. Does it mean that the same query runs much faster when you use SQL*Plus?

Could you post some more details? It is impossible to say anything about the issue as you didn't provide much information (tables' description, indexed columns, etc.). Could you, perhaps, post explain plan?

The way you've put it, I'd check whether columns you used in WHERE clause are indexed or not.
Previous Topic: Ref Cursor Query
Next Topic: parameter report
Goto Forum:
  


Current Time: Thu Dec 08 01:58:46 CST 2016

Total time taken to generate the page: 0.16716 seconds