I improved the speed by using the PARALLEL hint.

Words
24
Reading
1 min
Listen
Play
8y

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) */

I improved the speed by using the PARALLEL hint. | Ecency