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

performance is an attribute of a query, not of an index

whether or not an index is used depends on the query