I have general question regarding Oracle performance for Join VS Not Exists scenario.
I have the following query
FROM store_format sf
WHERE NOT EXISTS (SELECT 1
FROM STORE st
WHERE st.store_format_id = sf.store_format_id);
I am also attaching the explain plan for this.
Now my question is that can this query be written without using not exists condition, so that it performs better than the former query. In other words are Outer and Inner Joins better than Not exists when considering performance?
Any details would be very helpful.