The preceding topics showed that memory consumption in MODEL queries has a direct impact on their performance and scalability. They also showed that how a query is written can affect its memory consumption. In the remaining topics in this section we will see some simple tips for reducing MODEL query session memory requirements.
(As mentioned at the start of this section the content here only applies to Oracle 10g. These tips may not work in other versions.)