In message  <[log in to unmask]> [log in to unmask] writes:
 
 
> It says in the Allbase DBA guide (chapter 'Logical Design', section
> 'Determining Index Keys') that you must create an index on a primary key.
> [....]
> be an index too? I would say a pk should be an index automatically.
 
  Look at view SYSTEM.COMSTRAINTINDEX and you'll see info about indexes
  constructed for you automatically when an integrity constraint is
  defined in a CREATE (or ALTER) TABLE statement.
 
--
Mike Whiteley
Sector 7 Software
England