SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
S-56
Similarity Between Tables

Data within the tables

Column headings and help text

Catalog where the table is registered

Comments on columns, constraints, indexes, or tables

Number of partitions and partitioning key ranges

Key tags (or values) for indexes

Creation and redefinition timestamps

These file attributes can differ:
The AUDIT file attribute can also differ unless the program includes a statement
that performs a DELETE or UPDATE set operation on a nonaudited table with a
SYNCDEPTH of 1.

The number of indexes can differ, but all indexes used in the execution plan must
exist for both tables.

The table referenced at execution time can have more columns than the table
referenced at compile time if the common columns have identical attributes and if
the statement that references the table is not one of these:

An INSERT statement that does not explicitly specify names of columns into
which to insert values.

A statement that uses unqualified column names in a way that becomes
ambiguous because of the additional columns.

A statement that uses a SELECT list containing an asterisk, unless the asterisk
is of the form COUNT (*).
Tables referenced in statements such as these can be similar:
SELECT COUNT (*) FROM table;
SELECT columnx FROM tablea WHERE
columny relational-op (SELECT COUNT(*) FROM tableb);
ALLOCATE LOCKLENGTH SECURE
AUDITCOMPRESS MAXEXTENTS SERIALWRITES
BUFFERED NOPURGEUNTIL TABLECODE
CLEARONPURGE OWNER VERIFIEDWRITES
EXTENT (primary and
secondary)