16.20 - Usage Notes - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

Default Map for the User, Database, or Profile

The immediate owner of the join index can be a user or a database. See the CREATE USER DEFAULT MAP option, the MODIFY USER DEFAULT MAP option, the CREATE DATABASE DEFAULT MAP option, the MODIFY DATABASE DEFAULT MAP option, the CREATE PROFILE DEFAULT MAP option, or the MODIFY PROFILE DEFAULT MAP option.

User, Database, or Profile DEFAULT MAP OVERRIDE ON ERROR Option

If the map you specify does not exist, has not been granted to you, is not in the same secure zone, or the map is otherwise unavailable to you, a message indicates that the default map is being used instead of the map you specified. This is the default behavior if DEFAULT MAP OVERRIDE ON ERROR option is not specified for the user, database or profile. An error occurs only if DEFAULT MAP OVERRIDE NOT ON ERROR option is specified for the user, database, or profile.

Default Map for a CREATE JOIN INDEX Statement

If you do not specify the MAP option when creating a join index, the system determines a default map for the join index in the following order of precedence:
  • If the immediate owner is not the creator:
    • Default map, if defined, for the profile of the immediate owner.
    • Default map, if defined, for the immediate owner.
    • System-default map.
  • Default map, if defined, for the profile of the creator.
  • Default map, if defined, for the creator.
  • System-default map.

Secure Zones and Sparse Maps

For a sparse map, you must be in the same secure zone as the sparse map.