CBO? RBO? Very clear illustration

xiaoxiao2021-03-06  66

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

转载请注明原文地址:https://www.9cbs.com/read-119481.html

New Post(0)