I need to verify something on a primary key. I have a table which contains a Numero field of type Int. That field is defined as an identity field. However, when I do a query such as:

SELECT * FROM MyTable WHERE Numero=1000000

this takes a lot of time as if the index is not seen. What am I missing?