Home Forums SQL Server 2012 SQL Server 2012 - T-SQL How can we optimize a query having TABLE VALUED function in SELECT? RE: How can we optimize a query having TABLE VALUED function in SELECT?

  • April 3, 2013 at 9:07 am

    #1603235

    refactor your TVF to be an INLINE TVF and use that. Also push that SELECT ...(SELECT...) out like previous poster did.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service