0

I have a code header that looks something like this in SQL Developer:

    ALTER SESSION ENABLE PARALLEL QUERY
    SELECT /*+PARALLEL(dfam 32)*/
    distinct dfam.a,dfam.b from d_f_a_market dfam;

I am trying to use parallel query in R using RJDBC. I have a code that looks like this:

queryResults <- dbGetQuery(conn, "
SELECT /* +PARALLEL(dfam 32)*/
distinct dfam.a,dfam.b from d_f_a_market dfam;")

But I can't see any time improvement on using the hint. The query takes the same amount of time without sql hint. Any thoughts?

Aizen
  • 561
  • 1
  • 9
  • 19

0 Answers0