I improved the speed by using the PARALLEL hint.

in hints •  7 years ago 

The following links were well explained and referenced.
http://www.dba-oracle.com/t_parallel_hint.htm
https://docs.oracle.com/cd/E11882_01/server.112/e25523/parallel002.htm

The hints I've defined to improve speed are:
/*+ PARALLEL(12) /
or
/+ PARALLEL(CPD, 12) */

hints sql oracle parallel
7 years ago by

Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

  • Disagreement on rewards
  • Fraud or plagiarism
  • Hate speech or trolling
  • Miscategorized content or spam

Submit
$0.00
    3 votes
    0
    Authors get paid when people like you upvote their post.
    If you enjoyed what you read here, create your account today and start earning FREE STEEM!