当您在大型审核日志表格中运行查询功能时,您可能会在您的数据库系统不得不向缓冲池读入数千页面以进行计算时而结束。
When you run queries for very large audit log tables, you can end up with a situation where your database system has to read thousands of pages into the bufferpool to compute the result.
以下查询从提交的所有表格中查询用户ID并将它们以varchar形式返回。
The following query finds the userid from all submitted forms and returns them as varchar.
SAS数据在SAS程序中分析数据集,以编制统计,表格,报告,图表和绘图,创建SQL查询,并根据你的数据执行其他分析和操作。
SAS procedures analyze data in SAS data sets to produce statistics, tables, reports, charts, and plots, to create SQL queries, and to perform other analyses and operations on your data.
用户不但可以直接写MDX语句或通过图形化界面定制查询,还可以通过多维视图控件以表格、图形等多种方式浏览查询结果。
Users can customize query through both MDX statements and graphic interface, and browse the result by way of tables or graphs.
用户不但可以直接写MDX语句或通过图形化界面定制查询,还可以通过多维视图控件以表格、图形等多种方式浏览查询结果。
Users can customize query through both MDX statements and graphic interface, and browse the result by way of tables or graphs.
应用推荐