Hi,

Is there any major difference between using PARALLEL hint in the query and using parallelism object level (alter table ...... parallel 4)?

The only difference I can see is, with hint only the query with hint runs in parallel and with object level all the queries hitting that object will run in parallel.

Please correct me If my understanding is wrong.

Thanks,