Slawek Guzek (9/12/2010)

---

It is all about statistics and index selectivity.

You issued:

SELECT * FROM table WHERE fname='???'

It means that for every row found in index sever must perform...

Really thanks

I tested all of them!

But sql server (2008 R2 - x64) doesn't use index on about 6 millions of records,

but when records omitted to under 1 millions, use index!!!!

I...