Hello HainKurt,
I tried your logic but it doesn't resolve the problem... I don't believe it is supposed to improve performance either, because actually ANNUALSTATEMENTS is a quite a large table...
I had the same problem a while ago when I used the similar logic you provided... and by using "exists" keywords i was able to fix it. I really wonder what is the cause of this problem, since it only happens when I excute the select statement within a cursor like "select cursor (<above code>)mycur from dual"... Any other suggestion/advice would be appreciated!
Main Topics
Browse All Topics





by: HainKurtPosted on 2009-10-07 at 13:32:10ID: 25519723
intead of
SELECT *
FROM
ANNUALSTATEMENTS ANS,
(...) A
WHERE
...
AND EXISTS (...) --active members
ORDER BY
ANS.ID
you can use following structure, which I believe it will improve performance... and after that, you can rebuild all indexes on related tables... some indexes may be corrupt (it happened to me a while ago)
Select allOpen in new window