(Randolf Geist) If you consider the usage of Table Functions then you should be aware of some limitations to the optimizer calculations, in particular when considering a join between a Table Function and other row sources.
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help