Abstract
In the previous chapter, we learned about the Hobits (HoBT, Heap or B-Tree) – classic tables and indexes that are the most common objects in relational databases. In this chapter, you will learn about some special types of tables and indexes that can help you to build better designs for certainscenarios.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Notes
- 1.
There are some exceptions such as Large Objects (LOB) types that are placed outside of 8KB page.
- 2.
Columnstore structure has additional optimization that just marks values as invalidated and prevents decompressing and compressing column segments just for one change.
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2021 Davide Mauri, Silvano Coriani, Anna Hoffman, Sanjay Mishra, Jovan Popovic
About this chapter
Cite this chapter
Mauri, D., Coriani, S., Hoffman, A., Mishra, S., Popovic, J. (2021). More Than Tables. In: Practical Azure SQL Database for Modern Developers. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-6370-9_9
Download citation
DOI: https://doi.org/10.1007/978-1-4842-6370-9_9
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-6369-3
Online ISBN: 978-1-4842-6370-9
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)