FACT (table)—FACT指令指定在星型连接优化中使用的事实表。
Fact (table) - The fact directive specifies a fact table to be used during star join optimization.
STAR_JOIN—STAR_JOIN指令指示优化器尽可能地选择星型连接计划。
STAR_JOIN - the STAR_JOIN directive instructs the optimizer to favor a star join plan whenever possible.
所有新的星型连接指令都是查询层次的指令,会影响查询的执行。
All the new star join directives are query level directives that affect the execution of a query.
应用推荐