beautypg.com

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

Page 109

background image

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

database user

and

platform user

.

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:

replicate no

broadcast

and

replicate via broadcast

.

workload

A set of queries specific to a certain business function (or a set of business functions).

109