Query in
|
|
/ /
-----------------------------------
| Is the there a hint for table access, | | an orderd, first_rows or | | | | yes | 7.3 does any Table Have Parallel | ------> COST | SET? | | OR | | | | | | | 8.0 as Above and additionally, | | "| | | | | | | | | | | | | | | | | | 8.1 as Above and additionally, | | Are there,: | | domain indexes | | OR | | Parallelism Set on Indexes | | SEE [NOTE: 70008.1] | | OR | | Parallel Instances Set ON |
| An Object |
| OR |
| Sample Clauses |
DataWareHousing Feature |
| OR |
| Parallel CTAS |
| OR |
| Function-based indexes |
| OR |
| Reverse Key Indexes |
| OR |
Query Rewrite || |
| OR |
| ANSI JOIN SYNTAX IS USED |
| In the query |
----------------------------------- | | No | ----------- ------------------------ Yes | Is there a rule hint? | -------> Rule -------- ---------------------------
| | | NO |
----------------------------------- | Is rule set at system or session | Yes | Level and no choose Hint? | -------> Rule ----------------------------------- | | NO | ----------------------------------- | Is all_rows or first_rows set at | yes | system or session level And no | -------> COST | CHOOSE HINT? | --------------------------------- - | | NO | ----------------------------------- | Are there statistics for any of | YES THE TABLES? | -------> Cost ----------------------------------- || No | rule