Hi Sonali

Yes, that is it. We were also discussing with Chris the performance issue. As Chris noted, there two cases - one that is worth 3GL caching and the other is not.

From your experience, could you tell what query is faster - the one with MINUS or the one Chris suggested? Or there's no difference at all and Oracle treats them equally. For queries that return 10000 or more records this can make a difference.

Seralex