980551 wrote:Possibly, sure. Presumably, someone enabled parallelism on the table for some reason at some point in the past. Presumably, that solved some problem by, for example, allowing some other query to make use of parallelism.
will this have any offect on the DB if I turn off parrelism from the table level?
then I would no longer need to mention noparallel in this statement right?Assuming that both tables were set to NOPARALLEL, yes, you could omit the hint.