Reported By: Ole Willy Tuv Reported On: 6/18/2007 For: Version 1.04 Build 2
# 2381Very Slow EXISTS Performance on Larger Tables When investigating the EXISTS problem reported by Richard Harding in the NG,I noticed a severe performance problem with correlated subquery in the EXISTS predicate:
select ID, SField1, Stamp
from ATable t1
where not exists
(
select *
from ATable t2
where t2.ID = t1.ID
)
ResolutionFixed Problem on 6/23/2007 in version 1.04 build 3
Products AffectedElevateDB Additional Software and Utilities ElevateDB VCL Client-Server ElevateDB VCL Client-Server with Source ElevateDB VCL Standard ElevateDB VCL Standard with Source ElevateDB VCL Trial