Re: Fragments vs location of tables

"Irwin Goldstein" <irwinNOSPAM@NOSPAMobjectsoft.comNOSPAM> writes: >When doing round-robin, the indexes do NOT get fragmented along with >the table. This would make index lookups very inefficient. Round robin >fragmentation cannot be used for an index. 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 )