© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023
A. Nuijten, P. BarelModern Oracle Database Programminghttps://doi.org/10.1007/978-1-4842-9166-5_20

20. Choosing the Right Table Type

Alex Nuijten1   and Patrick Barel2
Oosterhout, Noord-Brabant, The Netherlands
Almere, Flevoland, The Netherlands

The purpose of any database is to store data. To do this, you create tables in your database. Oracle Database provides many different table types, each with its own strengths and weaknesses.

How the data is stored directly affects how efficiently the data is retrieved. It is not difficult to imagine that when data that is queried together is also stored together, it is faster than when data is stored all over the ...

Get Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.