Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
Some info here – Martin Smith Apr 27 '12 at 15:23

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.

share|improve this answer
So DBA does not need to worry about parsetree type objects. right? – hiren Apr 27 '12 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. – jgardner04 Apr 27 '12 at 15:17

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.