Location Use During OLTP Operations
If your system processes small transactions and no queries handle large amounts of data—as in an Online Transaction Processing system—then the use of all locations is more uniform and predictable. The Work location will be used less because smaller sorts occur in memory.
Last modified date: 04/03/2024