Now consider the following query, which USES the alias' SEC 'for the table name.
现在考虑下面的查询，将对表名使用“sec”作为别名。
Listing 2 creates a public alias for the newly create global temporary table so that it can be referred to as gtt_test without having to qualify the table name.
清单2将为新创建的全局临时表创建一个公有别名，以便于可以使用gtt _ test来引用它，而不需要限定表名。
Make sure that the alias and not the base table name is specified in the table attribute in the optimization guideline. For example, to request an XML index access for the following query.
确保优化准则的table属性中没有指定别名和基本表名。
应用推荐