OraFAQ Forum: Performance Tuning » Please tune this Query

Home » RDBMS Server » Performance Tuning » Please tune this Query

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Please tune this Query [message #161787]

Tue, 07 March 2006 03:39

hsinghalmrt
Messages: 51
Registered: March 2005

Member

Hi All,
Please provide me the help to tune the query like this 'Urgently'.

select peu_id, peu_option,
search.get_equip_no(peu_id,peu_option,peu_rev_no) equipment_no,
fts.fn_get_equip_name(peu_id,peu_option,peu_rev_no) eqpt_desc
from proposal_elements
where expiration_date is null and
equipment_no is not null and
equipment_no in (select distinct fts_equipment_no from fts_details
where prop_id = 24727 and
alternate_no = 1 and
fts_expiration_date is null and
fts_id_parent is null and
fts_option_parent is null)
connect by prior peu_id = peu_id_parent and
peu_option = peu_option_parent and
expiration_date is null
start with peu_id = 10364960 and
peu_option = 1 and
expiration_date is null

Thanks in advance.
Best Regards,
Himanshu

Report message to a moderator

Re: Please tune this Query [message #161905 is a reply to message #161787]

Tue, 07 March 2006 19:44

rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia

Senior Member

Quick! Quick! Hurry Himanshu! I need the current Explain Plan of your query, table sizes, available indexes, number of rows returned, and estimated performance stats for the user-defined functions (executions per second). And they better be wrapped in [CODE] ... [/CODE] tags, cos if I can't read it, I can't help.

I need it NOW, its URGENT!!
_____________
Ross Leishman

Report message to a moderator