I'm guessing here that the entire selection from the Oracle table (minus WHERE clause) is loaded into a dataset. PX datasets are memory-resident. (The alternative would be to go to Oracle for each reference lookup.)
Happy to be corrected.
What exactly does 'In Memory Lookup' from Oracle Mean
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: