Post reply

TOP N vs. TABLE HINT (fastfirstrow)

  • August 8, 2006 at 5:45 pm

    #169911

    [using: SQL Server 2005]

    I can't find any documentation that compares "TOP 1" with the table hint "fastfirstrow".

    Would there be any benefit to using both?  I know the server utilizes both in its query optimization plans...

    SELECT TOP 1 table_id FROM tbl (fastfirstrow); --both

    SELECT TOP 1 table_id FROM tbl; --top only

    SELECT table_id FROM tbl (fastfirstrow); --hint only

    --Eric Swanson
    http://www.ericis.com/

    Posts++;

  • August 8, 2006 at 6:19 pm

    #653959

    Did you try BOL?

    _____________
    Code for TallyGenerator

  • August 10, 2006 at 1:26 am

    #654209

    Okay... I've been around SQL Server for 7 years and had to figure out that "BOL" stood for Books on Line (sad, but true). Apparently the time to look things up and the time to type things out are what have brought us together.

    I checked "BOL" and after much, MUCH looking I found that "fastfirstrow", a synonym for "OPTION (FAST 1)" is being deprecated in future versions of SQL Server. So, although I never found any documentation comparing the 2 statements TOP and TABLE HINT (fastfirstrow), I now know to avoid the hint for the future.

    > Did you try BOL?

    Did you know the answer?

    --Eric Swanson
    http://www.ericis.com/

    Posts++;

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply