DEV Community

baris
baris

Posted on

Answer: SQL Performance, Using OPTION (FAST n)

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>





Very interesting detail

Top comments (0)