Taral Desai wrote:How can you tell it is not running in parallel?
Well this is not in parallel. So, may be something else is doing some other run on server. Or may be this would run in parallel at runtime.
1. Is there parallel set at table level ?As I mentioned before, I ran the tests without setting the DOP and with it being set
2. Some of the table are not analyzed .Yes they are. I had them analyzed on the 11/19. If I change the DOP or PARALLEL_MAX_SERVERS, should I re-gather stats?
3. some predicates are applied very late so may be you can try sub query unnestingI don't think this is happening.