Re: Horrible Query Performance, Simple Query -- Performance Tuning Help Needed

Here is the HDD_TRAN_2000 Function:

SELECT representation INTO rep

	FROM rsform, rsform_context
	WHERE rsform.rsform_id = rsform_context.rsform_id
		AND rsform_context.context_ncid = 2000
		AND rsform.ncid = ncid_to_translate
		AND rsform_context.preferred_score = 0
		AND rownum = 1;
	RETURN rep;

I'll run the trace with those events and post later today. Received on Thu Apr 20 2006 - 10:18:46 CDT