| when fetching data from database its take too much time and display in reports,? [message #258107] |
Fri, 10 August 2007 04:49  |
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  |
 |
Littlefoot
Messages: 21823
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
