Managing an Object File System Table | VantageCloud Lake - Managing an Object File System Table - Teradata VantageCloud Lake

Lake - Manage and Move Data
Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-05-16
dita:mapPath
atx1683670417382.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
atx1683670417382

Tables in the Object File System have different performance characteristics compared to tables in Block Storage.

Some of the limitations of Object File System tables:
  • No primary index
  • No secondary indexes
  • No hash indexes

When creating an Object File System table, the STORAGE option is a valid table level option in the CREATE TABLE statement.

Storage can also be defined at the database or user level.