Q: When to use parallel query with Oracle database?

A: With Oracle database, if columns in the where clause are not indexed, use the parallel hint
   may improve the query performance significantly.

   SELECT /*+ parallel(a) parallel(b) */ a.*, b.*
   from a, b where ...;