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?


1 Answer 1


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?
    – hiren
    Commented 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.
    – jgardner04
    Commented Apr 27, 2012 at 15:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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