'Normalizer' and 'Algebrizer' ?

Posted by Sarvesh under Sql Server on 9/24/2009 | Views : 3074 | Status : [Member] | Replies : 1
Dear SQL DBAs / Developers

What about the 'Normalizer' and 'Algebrizer' ?, Is there any relationship between this two ? Please explain.

Thanks in advance
Sarvesh S




Responses

Posted by: Pandians on: 9/24/2009 [Member] [MVP] Silver

Up
0
Down
Hi

Generally In SQL Server, When You submit a query the following activities taken place Internally:

1. Parser
2. Algebrizer (Normalizer)
3. Optimizer

- In SQL Server upto 2000, The term is 'Normalizer', But in 2005/2008 is called as 'Algebrizer' not 'Normalizer'( The tern replaced as 'Algebrizer')
- There is some internal changes are there between the two as follows..
A) The 'Normalizer' will not maintain any Optimization History, It will maintain only the replaced final value alone.
b) But, The 'Algebrizer' will maintain Optimization History. We can view the optimization history by
SELECT * FROM SYS.DM_EXEC_QUERY_OPTIMIZER_INFO
- The DMV will have three columns Counter, Occurrence & Value.

Note:
The history will clear when you Restart the SQL Service.

I hope its clear

Cheers

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Sarvesh, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response