Accessing Objects in Object File System Table - Teradata Vantage
Teradata® VantageCloud Lake
- Deployment
- VantageCloud
- Edition
- Lake
- Product
- Teradata Vantage
- Published
- January 2023
- Language
- English (United States)
- Last Update
- 2024-04-03
- dita:mapPath
- phg1621910019905.ditamap
- dita:ditavalPath
- pny1626732985837.ditaval
- dita:id
- phg1621910019905
- There are three steps to access an Object File System table:
- A single-AMP RETRIEVE step from the root object of the internal index that holds metadata for the table.
- An all-AMPs RETRIEVE step from leaf metadata from the internal index.
- An all-AMPs RETRIEVE step by way of external metadata, which accesses the table rows in external object storage.
- The row estimates in the Object File System metadata access steps represent:
- For the root access step, the number of leaf objects estimated to be accessed.
- For the leaf access step, the number of objects holding data estimated to be accessed.