You can specify an existing contiguous or sparse map for the table.
You must have been granted the specified map, except when you specify the same map determined to be the default map.
Specifying a map is optional. If you do not specify a map, the default map is determined according to 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.
See GRANT MAP in Teradata Vantage™ - SQL Data Control Language, B035-1149. Also, see the CREATE PROFILE DEFAULT MAP option and the CREATE USER DEFAULT MAP option.
- map_name
- Name of an existing contiguous or sparse map.
- COLOCATE USING colocation_name
- Optionally, you can specify a colocation name so that the tables reside on the same AMPs to avoid a redistribution of the rows when the tables are joined on a primary index or primary AMP index. For example, you can colocate two tables, then join the tables on the primary index or primary AMP index columns.