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

    #1603240

    Lynn Pettis (4/3/2013)

    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.

    That was a test Lynn - you PASSED!! :hehe:

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