CBO ? RBO? 很清晰的图示

                            QUERY IN 
                                |
                                | 
                          
    / /

                 -----------------------------------

                | Is there a hint for table access, | 
                | an ORDERED, FIRST_ROWS or         |
                | ALL_ROWS hint ?                   |
                |                                   |  yes 
                | 7.3+ Does any table have PARALLEL |-------> COST
                |      set ?                        | 
                |      or                           | 
                |      Partition Views involved?    | 
                |                                   | 
                | 8.0+ As above and additionally,   |
                |      Are there any:               |
                |      Index Organised Tables (IOT) | 
                |      or                           | 
                |      Partition Tables involved ?  | 
                |                                   | 
                | 8.1+ As above and additionally,   | 
                |      Are there any:               | 
                |      Domain Indexes (Inter Media) | 
                |      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                |

                |      (materialised views)         |

                |      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

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值