Improved Join Query Performance

A c-treeSQL query was observed to execute much slower after a recent code revision. Changes to enhance the selectivity for operators other than EQ had impacted this performance. A new approach to the selectivity calculation, as well as the case when the index is unique, has been taken which alleviates this slow query time.