>We tried it, but it's slower, than the methods described. Less code is not always correspond to the most efficient method.
OK, I agree. But I still think you should mention the alternative. You can mention, of course, that it is slower - and give some examples.
For example, sometimes I want to find orphan records only once, that is, I don't need to run a query every day. That is, once I find the offending records, I will turn on RI. And to run the orphan-query only once, or a few times, I don't really care if my code takes 10 seconds instead of 2. So I think there are uses for both approaches - the INDEXSEEK() approach (more code, and faster), and the subquery approach (less coding, but slower).
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
