fetch only first row from oracle - is it faster?
- by john
My main goal with this question is optimization and faster run time.
After doing lot of processing in the Stored Proc I finally return a count like below:
OPEN cv_1 FOR
SELECT COUNT(*) num_of_members
FROM HOUSEHOLD_MEMBER a,
HOUSEHOLD b
WHERE RTRIM(LTRIM(a.mbr_last_name))…