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 Go to next message](/forum/theme/orafaq/images/down.png) |
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 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.
|
|
|