curious_sqldba (5/16/2013)

---

Ok makes sense, i am joining on a table and a view, i might have to add this column on all the underlying tables...

I don't know what lay beneath your view, but indexed hash columns are an efficient alternative to performing non-equal joins on non-key and non-indexed columns. It's useful in a scenario where you need to know if at least one of X columns differ, but you arn't concerned with which specific column.