Does object level parallel hint affect the table settings for parallelism? Will statement level parallel hint apply to only that particular query and won't affect any default settings?

  • Can you give examples of what you mean? Query hints will never change table settings. Mar 28, 2022 at 8:35
  • Okay thanks. Can you brief about difference between object level and statement level parallel hint? Eg in object level we mention table name also /*+ PARALLEL(temp_table,2) */ vs statement level /*+ PARALLEL(2) */ Mar 28, 2022 at 10:28
  • 1
    Thanks for the comment clarifying your question. Can you edit your question to include that information. Also, the answer would depend on whether there are multiple tables in the query. Of course, if there is just one table in the query, the object level would be redundant. Keep in mind parallelism can be specified in the table definition also.... So clarify your question with full example queries, per minimal reproducible example. Mar 28, 2022 at 18:56


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.