Is it always necessary to have a primary key for a temporary table?
-
-
Primary keys are never required in DB2.
The only thing that a "primary key" clause gives you is that DB2 will create a unique index to support the unique rule specified in the primary key clause.
You could do the same by defining your own unique index (without using the "primary key" clause).
Or, as your question asks, you can create any table (temporary or otherwise) without indexes. Indexes are entirly optional.
Russ
Comment