View Single Post
  #9 (permalink)  
Old 01-06-05, 10:26
mwolf mwolf is offline
Registered User
 
Join Date: Dec 2004
Location: Kharkov, Ukraine
Posts: 40
This is execution plan of my result query:
|--Compute Scalar(DEFINE[Expr1002]=[dbo].[MyGetAllOnLine2]([Mail].[CC])))
|--Hash Match(Aggregate, HASH[Mail].[CC]), RESIDUAL[Mail].[CC]=[Mail].[CC]))
|--Clustered Index Scan(OBJECT[MWolf_Mail].[dbo].[Mail].[PK_Mail]))
It is better plan that I saw. Unfortunately, specific UDF is pay for good performance.
Reply With Quote