Option fast forces the query optimizer to not optimize the total runtime of the query, but the time it takes to fetch the first N rows.

if you have 2 tables of 1 million rows you want to join, a standard query plan is a hashmap of one table (temp…

</p>