Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012
    Posts
    2

    Unanswered: Index on Foreign Key with NULL

    Hi,
    We have a fact table with foreign key and this foreign key is joined to lookup table to get descriptions. I have added index on this foreign key to improve the join performance, but it is not performing better.

    Are there any types of indexes suited for foreign keys with nulls?

    Thanks
    Rav

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    performance is an attribute of a query, not of an index

    whether or not an index is used depends on the query
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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