issue tracking with oracle database
Bugzero issue tracking software
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 ...;

* Reference brought to you by Bugzero, it's more than just bug tracking software!

Home - FAQs