In nested loop joins optimizer first returns all the rows from row source 1 and Then optimizer probe row source 2 once for each row returned from row source 1. Useful when small subsets of data are being joined.