OLTP
A workload style optimized for high volumes of short, concurrent, state-changing business transactions.
Technical Context
OLTP performance is dominated by transaction latency, contention, log durability, index maintenance, connection management, and predictable query plans rather than large analytical scans. Schema and index design should follow operational access paths.
Related Concepts
- ACID
- transaction
- index
- connection pool