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. There will be many random small reads instead of scanning of data files. The Work location will be used less because small sorts occur in memory.
Last modified date: 01/30/2023