If have a table called Stk with about 39,000 records.
The Stk table has a primary key field called StockNo.
There is also a (Non-Unique) index on ParentStockNo.
Using SQL 2008 R2.
This query hangs...
Select * from Stk where ParentStockNo=27024
This query returns the number 23 instantly
Select count(*) from Stk where ParentStockNo=27024
Other users may be using the system. But currently no-one is doing editing. The Database is a test database - so not high volume yet & only me and another perseon testing it).
What is going on?