To avoid nested select statements we use SELECT FOR ALL ENTRIES statement. If there are more than 10000 records SELECT FOR ALL ENTRIES is used. Performance-wise SELECT FOR ALL ENTRIES is better to use.