Refrential integrity
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Refrential integrity

  1. 11-24-2000, 06:21 PM #1
    farrokhp
    farrokhp is offline Senior Member
    Join Date
    Nov 2000
    Posts
    416

    Exclamation

    Can somebody tell me that is it mandatory to have index on foreign key consatraint field?

    Thanks
    Reply With Quote Reply With Quote Share on Google+
  2. 11-25-2000, 12:12 PM #2
    tamilselvan
    tamilselvan is offline Moderator
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Yes. You must have.

    If the INDEX is not available, you will have performance problem.
    Reply With Quote Reply With Quote Share on Google+
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width