What is statman ?

[NathanGriffiths]

Whilst running a profile of some SQL generated by an application I came across this:

SELECT statman([record_change_status],@PSTATMAN) 
FROM (	SELECT TOP 100 PERCENT [record_change_status] 
			FROM [dbo].[#Browser____________..._______________0002000004C3] WITH(READUNCOMMITTED,SAMPLE 1.000000e+002 PERCENT) ORDER BY [record_change_status]) 
		AS _MS_UPDSTATS_TBL 
		OPTION (BYPASS OPTIMIZER_QUEUE, MAXDOP 1)

I'm wondering what "statman" is - is it something internal for SQL Server to do with statistics? A bit of Googling hasn't turned up anything about it, nor is it in help. Can anyone shed some light for me?

cheers

Nathan

----------------------------------------
Want to get a good response to your question? Read this FAQ! -> faq183-874
----------------------------------------

 

[vongrunt]

The only third-hand info I have about statman() claims it is used for automatic on-the-fly column statistics maintenance. This assumes that database options 'auto create statistics' and/or 'auto update statistics' are turned ON (default).