After making the connection to AMEE, we perform a drill-down query to get the correct data item for the information we want to store.
在连接到AMEE后,我们执行一个向下钻取的查询来获得针对我们想要存储的信息的正确的数据项。
This can be facilitated using the query drill down feature.
这可以使用查询钻取特性来完成。
You can drill down multiple levels in a query to specify nested predicates, clauses, and expressions.
您可以在一个查询中钻取多层,以指定嵌套的谓词、子句和表达式。
Query drill down allows you to gather statistical information about each SQL statement executed on the system and analyze statement history.
可以通过查询钻取特性收集关于系统上执行的每个sql语句的统计信息并分析语句历史。
The steps below illustrate how to work with the Query Drill-Down feature.
下面的步骤说明如何使用查询钻取特性。
Summary tables are required in a data warehouse for fast query processing and to allow users to drill up and down into the facts.
在数据仓库中需要汇总表,来实现快速查询,并允许用户在事实表中钻入钻出。
The query drill down feature helps determine the length of an SQL statement, the resources each statement USES, the length of the statement execution, the length of the resources wait time and so on.
查询钻取特性有助于判断sql语句的长度、每个语句使用的资源、执行语句的时间长度、等待资源的时间长度等等。
With any query, if you see something that looks unusual, you can always run additional reports or queries to drill down to more information.
对于任何查询,若发现有什么异常,可以随时运行附加报告或查询,以深入了解更多信息。
The statement type TAB in Figure 44 allows you to perform the query drill down by statement type.
在图44所示的StatementType选项卡上,可以按照语句类型执行查询钻取。
After a node is listed on the return grid, you can drill down into the query to add predicates and sorting preferences.
当一个节点在返回网格中被列出来时,就可以钻取(drill down)到查询中,添加谓词和排序方式。
Additionally, if your statement references a view, Query Annotation provides the ability to drill down into the SQL query in the view.
另外,如果语句引用一个视图,QueryAnnotation 允许向下钻取到视图中的SQL查询。
Rough Query: Rough Query provides near-instantaneous results for users who need to drill down into very large volumes of data.
概略查询:概率查询技术使得用户需要对海量数据进行深入查询时能近乎实时地得到结果。
Rough Query: Rough Query provides near-instantaneous results for users who need to drill down into very large volumes of data.
概略查询:概率查询技术使得用户需要对海量数据进行深入查询时能近乎实时地得到结果。
应用推荐