The Dixie Flatline - Thursday, January 10, 2019 2:56 PM
I guess I don't know what you mean. iTVFs will use the indexes of underlying tables just fine and, if used properly, will come into play just fine for joins and the like. I DO agree, however, that using Indexed Views is an incredible method for pre-aggregating data if you understand the effects they will have if you have rapidly changing table data that must be processed by Indexed Views.
--Jeff Moden
Change is inevitable... Change for the better is not.