Home Forums SQL Server 2005 SQL Server 2005 General Discussion Paging Problem SQL 2005 using row_number and order by RE: Paging Problem SQL 2005 using row_number and order by

  • May 13, 2009 at 6:05 pm

    #994224

    Views are treated no different than adhoc queries by SQL, unless you are doing Indexed Views. So the Execution plan for both adhoc and view will be the same.

    Raymond Laubert
    Exceptional DBA of 2009 Finalist
    MCT, MCDBA, MCITP:SQL 2005 Admin,
    MCSE, OCP:10g