1 ) Can we use parallel hint (/*+ parallel */) hint for a SQL query for parallel execution which is fetching more than 1 million of records inorder to speed up?.
2) Do parallel hint has any disadvantages ?. I have a insert into table where rows inserted by retrieving them from that select query . The (cost , bytes,cardinality showing low ) in explain plain shows good but its almost taking 25 mins to insert 750K rows.If i use paralle hint in the select query it ran in 4 to 5 mins . Please suggest whether i can use parallel hint to speed it up.
3) Is there any difference between parallel hint and parallel(auto) hint ?.