| Performance Degrads [message #285079] |
Mon, 03 December 2007 05:58  |
subbu_tce
Messages: 98
Registered: July 2007
Location: pune
|
Member |
|
|
The below query is taking time to execute and the records in the
tables are like in crores.....
Kindly suggests an alternate to the below query without using joins........
SELECT f.LEVEL_CODE,
f.DESCRIPTION,
f.master_code,
f.FACILITY_LEVEL_ID,
f.CHARGE,
P.ICD9_CODE,
P.CPT_CODE,
P.CPT_ICD9_ID,
FROM CPT_ICD9_PROCEDURES P, facility_level f
WHERE P.CPT_CODE(+) = f.LEVEL_CODE
AND f.FACILITY_NUMBER = :batch.facility_number
AND ACTIVE_FLAG = 'Y'
ORDER BY level_code,icd9_code;
|
|
|
|
| Re: Performance Degrads [message #285083 is a reply to message #285079] |
Mon, 03 December 2007 06:07  |
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
|
Senior Member |
|
|
if you had formatted your code ,then it would have been much better.By the way what do you mean by
| Quote: |
Kindly suggests an alternate to the below query without using joins
|
regards,
|
|
|
|
|
|
|
|
| Re: Performance Degrads [message #285086 is a reply to message #285084] |
Mon, 03 December 2007 06:29 |
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
|
Senior Member |
|
|
| Quote: |
I have used left outer join and because of this it taking time.
|
how did you arrive at this conclusion?there might be other reasons for your query's slow performence.
regards,
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Performance Degrads [message #285117 is a reply to message #285101] |
Mon, 03 December 2007 10:42 |
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
|
Senior Member |
|
|
Hi Mohammad,
should you really be editing someone's post in this way? I can see that editing a post to improve readability (removing IM speak, adding tags etc) can certainly be useful and valid, even removing abusive language I can see and agree with. But I'm not sure that censoring the above post is a valid use of this power. I saw the post and don't believe that it was particularly abusive, obnoxious yes, bleating yes but not abusive (although there was, what appeared to be, some foreign language text at the start of the post so I could be wrong and apologise if this is the case)
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
