Primary Key Constraint Question
Posted in 1997
Sub: Primary key constraint I need a little clarification on the subject of 'Primary Key Constraint'. I have never worked with this before. SYSTEM INFO: Unix, Informix Online Server 7.1 and 7.2 In ORACLE, as I was told, when you build a "Primary Key constaint", you can specify a dbspace where ORACLE will store the index file related to this "Primary Key". When creating an index, Informix let's you specify a dbspace where the index file will be stored. QUESTION: Assuming informix will create an index file when a 'PRIMARY KEY' contraint is used ( and apperantly hidden from me), Is there any way to tell informix server to put this file in a specific dbspace? I appreciate your help. Thanks. Bappy.