Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 .NET Inside SQL Server (2005)
 distinct on a CLR table function

Author  Topic 

lholden
Starting Member

5 Posts

Posted - 2008-05-16 : 05:08:31
I have written a table function, that returns data through the IEmunerator.
If add a distinct clause to my T-SQL select statement:

select distinct a,b
from tableFunc()

where does the distinct get executed?
Does it resolve the enumeration back to sql memory and then call the distinct?
does it/ can it do something clever and pass the distinction back to the enumerator?
Would there be (in general) any benift/performance gain in pulling the data back to a temp table first and then issuing the distinct over the temp table?

cheers

lee
   

- Advertisement -