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

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

Secure Zones and Sparse Maps

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