Jerry Nixon @Work: Using the SQL 2005 FAST hint

Jerry Nixon on Windows

Friday, March 14, 2008

Using the SQL 2005 FAST hint

Back in 2005 I presented at SQL PASS. It was, in part, on the new FAST hint in SQL 2005. I explained how to use it and why to use it. Since then, I have forgotten.

Here's the syntax, but I can't remember for the life of me why to use it. Do you?

/*
    FAST hint
*/
SELECT * FROM Customers
    OPTION(FAST 10)