
New theory to avoid Key Lookup and Scan operations in SQL Server Database Engine.
Is it possible to take both clustered and non-clustered indexes advantage at one time? Or in other word, is it possible to search data without worrying about edge key in the index?