When you specify the NOLOCK hint, the query both doesn’t issue shared locks and also doesn’t care about already existing exclusive locks. Thus, you will get the result back very fast, but at the risk of probably being incorrect.