I have 3 queries which basically the same but hitting different DBs. One of the query do not using parallism and it is take hours to load 15m rows compared to another that takes 1 hr to load 150m rows.
I know the optimizer decide when to use parallelism. What can i change to affect the optimizer other than changing the query.
MAXDOP option does not have any effect.