Some hint
来源:互联网 发布:mac ai如何剪切图片 编辑:程序博客网 时间:2024/04/30 05:38
ORDERED LEADING
The ORDERED
hint causes Oracle to join tables in the order in which they appear in the FROM
clause.
If you omit the ORDERED
hint from a SQL statement performing a join, then the optimizer chooses the order in which to join the tables. You might want to use the ORDERED
hint to specify a join order if you know something about the number of rows selected from each table that the optimizer does not. Such information lets you choose an inner and outer table better than the optimizer could.
The LEADING hint causes Oracle to use the specified table as the first table in the join order. If you specify two or more LEADING hints on different tables, then all of them are ignored. If you specify the ORDERED hint, then it overrides all LEADING hints.
/*+ leading (table) */
- Some hint
- Hint of Some Interesting Webs from LinuxSir
- Hint
- hint
- Hint
- hint
- hint
- hint
- hint
- HINT
- HINT
- some
- some
- some
- some
- some
- Some
- some
- 走进自己的内心
- 关于Bind Variables Peeking
- View statistics in the data dictionary
- 关于同操作系统的32bit到64bit的数据库迁移参考文档
- rebuild和rebuild online的区别
- Some hint
- 一条SQL语句如何被解析
- 关于CURSOR_SHARING三个取值的区别
- Shared Pool的一点理解
- [用友]年度结转
- 能否再给爱一次机会
- ASP.NET 的自定义控件>显示继承控件图形的问题
- library cache lock wait event
- 关于存储过程的ADO调用的一些心得(输出参数,返回值)