Does query plan optimizer works well with joined/filtered table-valued functions?

by

In this case, it’s an “inline table valued function”
The optimiser simply expands (unnests) it if it’s useful (or view).

If the function is treated as “black box” by the outer query, the quickest way is to compare IO shown in SSMS vs IO in profiler.
Profler captures “black box” IO that SSMS does not.

Blog post by Adam Mechanic (his book is in my drawer at work)

More Related Contents:

  1. Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
  2. T-SQL: Opposite to string concatenation – how to split string into multiple records [duplicate]
  3. Check if table exists in SQL Server
  4. Sql Server string to date conversion
  5. Insert multiple rows WITHOUT repeating the “INSERT INTO …” part of the statement?
  6. Does T-SQL have an aggregate function to concatenate strings? [duplicate]
  7. Parameter Sniffing (or Spoofing) in SQL Server
  8. How to get Time from DateTime format in SQL?
  9. SQL Server String or binary data would be truncated
  10. Datatype for storing ip address in SQL Server
  11. How to change identity column values programmatically?
  12. Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?
  13. How much size “Null” value takes in SQL Server
  14. best way to convert and validate a date string
  15. SQL Server ORDER BY date and nulls last
  16. How to remove accents and all chars a..z in sql-server?
  17. Find non-ASCII characters in varchar columns using SQL Server
  18. WHERE clause on SQL Server “Text” data type
  19. SQL Server error on update command – “A severe error occurred on the current command”
  20. Aggregate bitwise-OR in a subquery
  21. SQL server schema and default schema
  22. OR Operator Short-circuit in SQL Server
  23. how to write number to word function in sql server [closed]
  24. SQL Server 2008 – How do i return a User-Defined Table Type from a Table-Valued Function?
  25. Check if a string contains a substring in SQL Server 2005, using a stored procedure
  26. FOR XML PATH(”): Escaping “special” characters
  27. What are row, page and table locks? And when they are acquired?
  28. @@ERROR and/or TRY – CATCH
  29. SELECT FOR UPDATE with SQL Server
  30. SQL Server: combining multiple rows into one row

Leave a Comment