Hello,
I recall reading about a problem with subselects taking a long time to
return. I am experiencing similar problems under 6.3.1 running on Linux
RedHat5.0. The tables only contains approx 2k records and the command
ran for about 10 minutes.
Thanks,
Edwin Ramirez