Home » RDBMS Server » Performance Tuning » Please help to Tuning (Please help to Tuning)
Please help to Tuning [message #329077] Tue, 24 June 2008 00:23 Go to next message
bagulia_pilla
Messages: 25
Registered: July 2006
Junior Member
SELECT DISTINCT
    subprofile1.CMS_LE_SUB_PROFILE_ID,
    subprofile1.LSP_SHORT_NAME,   	
    rel.REL_VALUE,
    (SELECT code.ENTRY_NAME 
                  FROM common_code_category_entry code
                  WHERE code.ENTRY_CODE = rel.REL_VALUE
                 AND code.CATEGORY_CODE = 'ENT_REL' 
    ) AS RELATION_NAME 
FROM sci_le_rel rel, 
     sci_le_sub_profile subprofile,
     sci_le_sub_profile subprofile1  
WHERE rel.CMS_LE_SUB_PROFILE_ID = subprofile.CMS_LE_SUB_PROFILE_ID 
     AND subprofile1.CMS_LE_SUB_PROFILE_ID  = rel.PARENT_SUB_PROFILE_ID
     AND subprofile1.CMS_LE_SUB_PROFILE_ID  <> subprofile.CMS_LE_SUB_PROFILE_ID
     AND rel.STATUS <> 'DELETED' 
    ORDER BY RELATION_NAME ASC
Re: Please help to Tuning [message #329078 is a reply to message #329077] Tue, 24 June 2008 00:24 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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

& your question is exact WHAT?
Re: Please help to Tuning [message #329083 is a reply to message #329077] Tue, 24 June 2008 00:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SELECT 'Tuned' FROM dual;

Regards
Michel
Re: Please help to Tuning [message #329090 is a reply to message #329077] Tue, 24 June 2008 01:07 Go to previous messageGo to next message
bagulia_pilla
Messages: 25
Registered: July 2006
Junior Member
Hi,
I am using this query to retrieve customer info but it is taking long time .. so can this query be optimised ?
-thanks
Re: Please help to Tuning [message #329095 is a reply to message #329090] Tue, 24 June 2008 01:32 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe yes, maybe no, how could we know with what you posted?

You can first read:
- OraFAQ Forum Guide, Performance Tuning section
- How to Identify Performance Problem and Bottleneck
- OraFAQ Performance Tuning
- Rosco's SQL Tuning Guide

Then provide the requested and usual information.

You can also have a look at Database Performance Tuning Guide.

Regards
Michel
Previous Topic: Capturing top 10 longest running SQLs
Next Topic: Tuning for Queuing (merged)
Goto Forum:
  


Current Time: Sat Dec 10 18:39:42 CST 2016

Total time taken to generate the page: 0.06951 seconds