Refrential integrity
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. 11-24-2000, 07: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
  2. 11-25-2000, 01:12 PM #2
    tamilselvan
    tamilselvan is offline Moderator
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    Yes. You must have.

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

Bookmarks

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