创建一个SQC文件来执行主查询。
不能在主查询中使用多个外部表。
主查询要求,子查询指定子元素的属性。
The main query asks for; the subquery specifies properties of child.
从目录表中查找主查询的包和片段信息。
Find the package and section information for the main query from the catalog tables.
第2步—运行Query 1 . sql的主查询。
每一个sggrep命令可以同时指定主查询和子查询。
Each sggrep command can specify both the main query and a subquery.
在下面的查询中替换之前的步骤中找到的信息,从而捕捉主查询的活动。
Capture the activity for our main query by the substituting information we have found in previous step in the following query.
这说明子查询SELECT语句可以单独存在,并不依赖于主查询语句。
This implies that a subquery SELECT statement can stand alone, and it does not depend on the statement in which it is nested.
OLTP查询中很少需要选择查找表作为需要相关表上的索引来支持联接的主查询表。
It is rare in an OLTP query for the lookup tables to be selected as the primary query tables requiring an index on the dependent table to support the join.
如果有异步,那么当主查询开始时,所有在它们的上一层有at Q操作符的SHIP也随之开始。
With asynchrony, all SHIPs with an ATQ operator directly above them would start at the same time as the main query starts.
如果主查询表拥有大量数据,比如数百万行,那么向明细端上的数据库表发出的查询量可能难以接受。
If the master query table has a large volume of data, perhaps millions of rows, then there might be an unacceptable amount of queries issued to the database table on the detail side.
我们首先在第一个会话中(本例中是SESSION1)发出主查询,这样我们就能够得到运行时片段解释的目标。
We first issue the main query from one session (SESSION1 in this example) that we would like to see the runtime section explain for.
也就是说,他们提供了一个初始主查询,该查询可以保证搜索系统至少能够访问他们感兴趣的区域中的一些文档。
That is, they issue an initial broad query that reassures them that the search system gives access to at least some documents in the area they are interested in.
由于列表对象关联到没有摘要过滤器的主查询,报告现在以DynamicQueryMode执行,并返回预期结果。
With the list object associated to the master query without the summary filter, the report now executes using Dynamic query Mode and returns the expected results.
在这个场景中,列表对象需要关联到一个新的主查询,该查询只包含没有摘要过滤器的Productline数据项。
In this scenario, the list object will need to be associated to a new master query which consists of only the Product line data item with no summary filter.
通常情况下,业务系统用户通过各自的业务系统更新和查询主数据。
Business system users update and query master data typically through the use of their respective business systems.
您还可以复制数据库(一个主数据库,多个副本),从而在多个CPU之间分担查询处理的负担。
You can also replicate a database (one master, many copies) to share the burden of query processing among many CPUs.
这个例程查询接口的标识符和接口uuid的主版本或次版本。
This routine is called to inquire about the interface's identifier and major or minor versions of the interface's UUID.
交叉表的分区将Productline查询项目放置到标头中,生成了一个“主-细节”关系。
The sectioning of the crosstab places the Product line query item into the header and generates a master-detail relationship.
为完成这一查询,该服务为当前已验证用户查找主邮件服务器,然后查找该服务器所属集群的ClusterName。
To do this query, the service looks up the home mail server for the current authenticated user and then looks up the ClusterName of which this server is a part.
在复制架构中,一个Solr服务器充当主服务器,负责向一个或多个处理查询请求的从服务器提供索引的副本(称为snapshot)。
In a replicating architecture, one Solr server ACTS as the master server, providing copies of the index (called snapshots) to one or more slave servers that handle query requests.
除非它找到一个查询或定义,否则它会都在主循环中触发消息。
Unless it finds one or the other, it triggers a message in the main loop.
典型的方法是根据实体的主关键字进行查询,因为这可以保证产生一个独一无二的结果。
The typical method is to look up the entity by its primary key, because that will guarantee a unique result.
如果数据库设计者已在表上创建了主分区索引,那么查询应当与分区列结合。
If the database designer has created a Primary partition Index on a table, queries should incorporate the partitioning column.
任何利用主索引列的查询将会遭遇更快速响应时间问题。
Any query that utilizes the Primary Index column will encounter faster response times.
基本的原理是让主数据库处理事务性查询,而从数据库处理SELECT查询。
The basic concept is to have a master database handle transactional queries while slaves handle SELECT queries.
索引命令发送到主服务器,查询则发送到从服务器。
Indexing commands are sent to the master server and queries are sent to the slave servers.
因此,您应仅执行该JNDI查询一次,然后存储所检索到的主对象(例如,存储在实例中或静态变量中)。
Therefore, you should perform the JNDI lookup once only, and then store the retrieved home object (for example in an instance or static variable).
Solr还提供了主-从索引复制机制,以便在大规模的应用中分散查询负载。
Solr also provides a master-slave index replication mechanism to allow query load to be distributed in a large-scale environment.
Solr还提供了主-从索引复制机制,以便在大规模的应用中分散查询负载。
Solr also provides a master-slave index replication mechanism to allow query load to be distributed in a large-scale environment.
应用推荐