I have a query

Select .....
Where z not in
( select .....)

There are a few duplicates in the sub query, but not many. I know a
disctinct is slower, but in this caes it would possibely speed up the first
select? Which would be a "general" better strategy. To add distinct to the
subquery or no?

--
Chad Z. Hower aka Kudzu
"Programming is an art form that fights back"

Still doing your website by hand? Get a free content management system:
http://www.atozed.com/iws/