Still a little unclear what happened if we don't have an index on FK, when it cause full scan performance killer and any other disadvantage. Can you explain your reason with EMP, DEPT tables.

Thanks Farrokh