DEV Community

loading...

Answer: SQL Performance, Using OPTION (FAST n)

boyukbas profile image baris ・1 min read

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

Discussion (0)

pic
Editor guide