I have looked into sys.syscachedobjects table. I found some records have an object type of parsetree.
Can anyone tell me in detail what a parsetree is? Is this a data structure used by SQL Server, and can it help simplify my job as a DBA?
-
1en.wikipedia.org/wiki/Parse_tree– Aaron BertrandCommented Apr 27, 2012 at 14:14
-
Some info here– Martin SmithCommented Apr 27, 2012 at 15:23
Add a comment
|
1 Answer
The breakdown of your code by by SQL server is checked by the engine for any issues. If it does not find them it generates a parse tree and passes it to the algebrizer. It is another way to represent the query.
-
So DBA does not need to worry about parsetree type objects. right?– hirenCommented Apr 27, 2012 at 15:08
-
It is an important concept for understanding query optimization. You can take a look at the link Aaron posted above for some good information. If you want more information regarding query performance and Execution Plan Cache Analysis I would recommend that you get a copy of SQL Server 2008 Query Performance Tuning Distilled. Commented Apr 27, 2012 at 15:17