I had speed example of using cursor and select:

In my previous project "data migration". using cursor would spend more then TWO days, with select, it just 30 min. There were about 200K total customer records