Home > IT Answers > Database > Infinite recursion in SQL Server 2000
Gomsbk
35 pts.
 Infinite recursion in SQL Server 2000
Query optimization, Recursion, SQL Query, SQL query optimization, SQL Server 2000
consider a recursive query in SQL.How to handle infinite recursion to make the query evaluation optimized?



Software/Hardware used:
SQL server 2000
ASKED: September 27, 2010  6:52 AM
UPDATED: October 2, 2010  6:04 PM
RELATED QUESTIONS
Answer Wiki:
infinite recursion and query optimization are pretty much mutually exclusive. If you can post the table design and the query (or a simplified version of it) it might help.
Last Wiki Answer Submitted:  October 2, 2010  6:04 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _