Foreign key index rebuild in 8i STD
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Foreign key index rebuild in 8i STD

  1. #1
    Join Date
    Aug 2001
    Posts
    11
    How do I rebuild the foreign key indices on a database?

    Some of these are composit FK indices. On such cases, would enabling and disabling the FK, fix the issue of rebuilding?

    Could some one give me steps on how to do this?

    Mr. T

  2. #2
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262
    What do you mean by rebuilding?
    Do you need to drop the indexes for a specific purpose and put them back again?
    If so, disable and enable will work.
    Hemant

  3. #3
    Join Date
    Jan 2001
    Posts
    3,131

    Smile

    I PITY DA FOOL WHO GIVE MR.T DA WRONG ANSWER!!
    MH

  4. #4
    Join Date
    Aug 2001
    Posts
    11
    The reson behind this question was, I have oem setted to monitor the index fragmentation. Now is shows that there are a number of FK indexes need to be rebuilt to remove fragmentations. I know the rebuild for a regular index, but since this being the index on the foreign key index, how should I do.

    Is disable of PK necessary/ just the disable of FK would fix?

    I would really appreciate if, someone tell me the steps to take?

    I'm also curious to know how this indexing work?

    Mr. T

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width