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:10 am

    #1603237

    TheSQLGuru (4/3/2013)

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

    Actually, the TVF being used is an in-line TVF.