Nonhashed Data Dictionary Tables | VantageCloud Lake - Nonhashed Tables - Teradata Vantage

When a table is nonhashed, the rows of the table are not distributed using hash maps and are instead stored AMP-locally. For example, each row of the DBC.DatabaseSpace table keeps track of the space used locally by one AMP. Similarly, recovery tables only contain the information necessary to recover any activity or transaction that occurred on their own AMP.

Acctg and DatabaseSpace are allowed for SHOW TABLE, HELP, and so on, and these two tables can be queried if you have the privileges for running the statement on the table. SHOW TABLE and HELP INDEX indicate that these two tables, though nonhashed, have unique primary indexes.

The other tables have special formats for their rows and cannot be queried and are not allowed for SHOW TABLE and so on (an error is returned that the table cannot be accessed).

The following table lists the nonhashed and NO FALLBACK Data Dictionary tables.