Tdm_default_datasource, Type 2 join – HP Neoview Release 2.5 Software User Manual
Page 109

the users who are granted a role are granted the privileges associated with the role. The Neoview
platform can have a maximum of 255 roles. See also
and
.
SQL statement
Any DML or DDL statement including, but not limited to SELECT, INSERT, UPDATE, DELETE,
CREATE, ALTER, DROP, GRANT, and REVOKE.
TDM_Default_DataSource
TDM_Default_DataSource is the default data source for database access. You cannot delete
TDM_Default_DataSource, but you can configure other data sources.
token
Additional information about an operator found in the Description column of the Explain
output.
type 1 join
A parallel execution plan in which matching partitions exist in tables that are involved in a
plan.
type 2 join
A parallel execution plan the optimizer achieves by using parallel access to the inner table. The
optimizer may choose this type of plan when the inner and outer tables do not match and
repartitioning is undesirable or not possible. Two forms of the type 2 join exist:
and
workload
A set of queries specific to a certain business function (or a set of business functions).
109