Thank you for the response. I would start a new one and will give more details. Thanks!:-)

Need help please.. We are experiencing PageIOLatch_* and spid being blocked by itself. the query goes like this. Not sure if this is index problem but we already tried to...