Skip to main content

Introducing new learning courses and educational videos from Apress. Start watching

Book cover

Practical Azure SQL Database for Modern Developers pp 235–265Cite as

Apress

More Than Tables

  • 927 Accesses

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, access via your institution.

Chapter
USD   29.95
Price excludes VAT (USA)
  • DOI: 10.1007/978-1-4842-6370-9_9
  • Chapter length: 31 pages
  • Instant PDF download
  • Readable on all devices
  • Own it forever
  • Exclusive offer for individuals only
  • Tax calculation will be finalised during checkout
eBook
USD   29.99
Price excludes VAT (USA)
  • ISBN: 978-1-4842-6370-9
  • Instant PDF download
  • Readable on all devices
  • Own it forever
  • Exclusive offer for individuals only
  • Tax calculation will be finalised during checkout
Softcover Book
USD   39.99
Price excludes VAT (USA)
Learn about institutional subscriptions
Figure 9-1
Figure 9-2
Figure 9-3
Figure 9-4
Figure 9-5
Figure 9-6
Figure 9-7
Figure 9-8

Notes

  1. 1.

    There are some exceptions such as Large Objects (LOB) types that are placed outside of 8KB page.

  2. 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

  1. Redmond, WA, USA

    Davide Mauri & Sanjay Mishra

  2. Legnano, Milano, Italy

    Silvano Coriani

  3. Sherman Oaks, CA, USA

    Anna Hoffman

  4. Belgrade, Serbia

    Jovan Popovic

Authors
  1. Davide Mauri
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Silvano Coriani
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Anna Hoffman
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Sanjay Mishra
    View author publications

    You can also search for this author in PubMed Google Scholar

  5. Jovan Popovic
    View author publications

    You can also search for this author in PubMed Google Scholar

Rights and permissions

Reprints and Permissions

Copyright information

© 2021 Davide Mauri, Silvano Coriani, Anna Hoffman, Sanjay Mishra, Jovan Popovic

About this chapter

Verify currency and authenticity via CrossMark

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