SQL SERVER – Challenge – Puzzle – Usage of FAST Hint
- by pinaldave
I was recently working with various SQL Server Hints. After working for a day on various hints, I realize that for one hint, I am not able to come up with good example. The hint is FAST.
Let us look at the definition of the FAST hint from the Book On-Line.
FAST number_rows
Specifies that the query is optimized for fast retrieval of the first…