Storage Structures and Index Design and Performance
Choosing the correct table storage structure for your needs can improve concurrency and query performance. Remember that there is no substitute for testing and benchmarking your queries.
For tips on choosing storage structures and advantages and disadvantages of the various storage structures, see the chapter “Choosing Storage Structures and Secondary Indexes.” For information on modifying and compressing storage structures and a discussion of overflow, see the chapter “Maintaining Storage Structures.”
Last modified date: 08/29/2024