Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jambu Krishnamurthy Table Variables RE: Table Variables
SuperDBA-207096
SSCrazy Eights
Points: 8176
More actions
November 21, 2006 at 6:34 am
#673180
Mark,
I've found that UDF's that return table variables, or larger data sets tend to be awful slow, since the returned 'table' ends up not using any indices. If you can avoid a UDF that returns a dataset (table) I would do so!
Mark