Re: They wanna know why it takes so long .....

Not only the distinct is causing the problem but the outerjoin. Consider replacing distinct with and exists statement in the where clause. That can sometimes reduce your result set down to where you don't need the distinct. Received on Sat Mar 15 2003 - 07:45:13 CST