thanks for the replies. Yes the result is same after multiple runs, the indexes were enabled. When i backup and restore the same db there is an option under the indexes "Use Index" that was checked and wasn't checked on the original one. My question is why is it checked when restored and not on the original one.. Thanks