Performance issue on query over nested recursive objects

Performance issue on query over nested recursive objects

References

Reference NO 1

http://stackoverflow.com/questions/15205555/performance-issue-on-query-over-nested-recursive-objects

Reference NO 2

http://www.kamfonas.com/id3.html

Reference NO 3

http://blogs.msdn.com/b/sqlcat/archive/2011/04/28/optimize-recursive-cte-query.aspx

Reference NO 4

http://www.coderanch.com/t/570828/ORM/databases/Recursive-fetch-join-recursively-fetching

Reference NO 5

http://wwwis.win.tue.nl/~tcalders/teaching/advancedDB09/slides/ADB09-01-OO.ppt

Reference NO 6

http://blog.sqlauthority.com/2009/08/08/sql-server-multiple-cte-in-one-select-statement-query/

Reference NO 7

http://docs.oracle.com/cd/E16655_01/server.121/e15858/tgsql_glossary.htm

Reference NO 8

#EANF#