How about this??? Using timing and autotrace should give you a good measure on how the two queries measure up.
Code:SET TIMING ON SET AUTOTRACE ON SELECT sf.store_format_id FROM store_format sf LEFT OUTER JOIN STORE st ON st.store_format_id = sf.store_format_id WHERE st.store_format_id IS NULL;




Reply With Quote