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属性中没有指定别名和基本表名。
2
When you execute a MakeTablequery, no results are reported in the results pane.
当执行“生成表”查询时，“结果”窗格中不报告结果。
3
You can copy rows into a new table using a Maketablequery, which is useful for creating subsets of data to work with or copying the contents of a table from one database to another.