Index Creation Questions

Can someone answer some basic general questions? 1. what is the difference between creating a unique index on a column via the create unique index statement versus using the primary key constraint when creating the table. 2. what is the difference between creating an index on a column via the create index statement versus using the alter table and adding a foreign key constraint. 3. what does the dbexport/dbimport facility do when indices are created by using constraints versus the create index statement, specifically when the dbimport creates the table, is the data then loaded before the constraints create the index??????? > Carol Schultheis > GIS DBA Team > Harrison: (914) 253-7801 Fax: (914) 253-7154 (Mon-Thurs) > Beacon: (914) 838-7288 Fax: (914) 838-7110 (Wed-Tues-'A' Fri) > Pager: (914) 545-7545 > > >