InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is Spool Space And When Running A Job If It Reaches The Maximum Spool Space How You Solve The Problem? |
|
Answer» Spool space is used to hold intermediate rows during processing, and to hold the rows in the answer SET of a transaction. Spool space REACHES maximum when the query is not properly optimized. Use APPROPRIATE conditions in WHERE clause of the query to LIMIT the answer set. Spool space is used to hold intermediate rows during processing, and to hold the rows in the answer set of a transaction. Spool space reaches maximum when the query is not properly optimized. Use appropriate conditions in WHERE clause of the query to limit the answer set. |
|