Re: Fragments vs location of tables

francisco@natserv.com wrote in article <34d0eef6.0@news2.ibm.net>... > "Irwin Goldstein" <irwinNOSPAM@NOSPAMobjectsoft.comNOSPAM> writes: > <snip> > I will create an unique index on my key and then create the primary key > constraint. > > How about foreign key index. They seem to have the same characteristic > as primary key index? should I make index on the fields where the foreign > key is before doing the foreign constraint? (I mean the index on the child table ) Yes, if you want to control exactly how and where the index gets created (including its name, dbspace location, fragmentation strategy, etc.) then you should create the index first, then add the constraint after the index is created.