• I would like to know why non-clustered index on three or more columns does not work even when the columns are put in the same order as in the index and instead of that clustered index scan is called in the Execution plan.

    I found through search that Non clustered index is not called because my where clause was not enough selective but what if I need more data and retrieval should be fast.