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, access via your institution.
There are some exceptions such as Large Objects (LOB) types that are placed outside of 8KB page.
Columnstore structure has additional optimization that just marks values as invalidated and prevents decompressing and compressing column segments just for one change.
Rights and permissions
© 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
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-6369-3
Online ISBN: 978-1-4842-6370-9
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books