[QUOTE In other words are Outer and Inner Joins better than Not exists when considering performance?

Any details would be very helpful.

Regards,
Neha[/QUOTE]

If Joins were better then NOT Exists and Not in then the optimizer would start re-writing those queries transparently .

The answer to your question is it depends on the scenario and many other things (like indexes).You need to bench mark and see.

By the way i don't see a plan attached anywhere

regards
Hrishy