When issuing a query to retrieve data from the database, the Oracle query optimizer quickly determines the most efficient way to return the requested information. The “path” to the data consists of accessing the table, or using an index, or a combination of tables and indexes. In this mode, the path entails Oracle reading table blocks from disk into memory in order to access the data. Within the blocks, rows of table data are stored. This ...
© Darl Kuhn, Sam R. Alapati and Bill Padfield 2016
Darl Kuhn, Sam R Alapati and Bill Padfield, Expert Oracle Indexing and Access Paths, 10.1007/978-1-4842-1984-3_10
10. In-Memory Column Store
Darl Kuhn1 , Sam R. Alapati2 and Bill Padfield3
(1)Morrison, Colorado, USA
(2)Flower Mound, Texas, USA
(3)Aurora, Colorado, USA
Get Expert Oracle Indexing and Access Paths: Maximum Performance for Your Database 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.
