number of rows
行数
2026-03-21 22:55 浏览次数 19
行数
The optimizer ACTS based on statistical data about the number of rows in a table, the use of space by a table or index, and other information.
优化器的操作基于数据表中的行数、数据表或索引使用的空间以及其他信息的相关统计数据。
Even if the number of rows in a table remains consistent, changes in data contents can result in different, and hopefully better, access paths using statistics updated by RUNSTATS.
即使表的行数保持一致,使用由RUNSTATS更新的统计信息来更改数据内容可以产生不同的、也许更好的访问路径。
The combination of columns then provides the required uniqueness so you can have an arbitrary number of rows in the database table.
列的组合能提供所需的唯一性,使您的数据库表中能拥有任意数量的行。
Due to our limited number of rows in this data set, the visualization is not as powerful as it would be if there were more data points (in the hundreds, for example).
由于在这个数据集内的行数有限,因此可视化的功能显得没有有更多数据点(比如,有数百个)时那么功能强大。
It allows applications to specify the starting row of the fetch and the number of rows to be fetched from the database.
它允许应用程序指定从数据库中所取的起始行,以及所取的行数。
Performance benefits are realized when an index reduces the number of rows (or tuples) examined by the DBMS during query execution.
索引可以减少DBMS在执行查询时检查的行(或元组)数量,从而获得性能增益。
It includes job name, job execution times, number of rows processed, error or success status, time started, and time completed, which are all described in sequence.
它包括作业名称、作业执行次数、处理的行数、错误或成功状态、开始时间及完成时间,这些都是按顺序描述的。
The number of rows retrieved from the outer table after the database server applies any table filters is small, and the inner table has an index that can be used to perform the join.
在数据库服务器使用所有表筛选器之后,从外部表检索出的行数将很少,而内部表具有一个可用于执行连接的索引。
Using this option reduces the amount of page contention by introducing free space in the table, and hence reducing the number of rows on a single page.
通过使用该选项,可以在表中引入空閑空间,以减少页面争用,从而减少单页上的行数。
The optimizer calculates its cardinality estimate — that is, the estimated number of rows returned by the query — based on the statistics available.
优化器根据可用的统计信息计算基数的估计值,即预计查询返回的行数。
You should be able to select the number of rows to be displayed from a drop down list.
您应该能够从一个下拉列表中选择要显示的行数。
The maximum number of applications allowed to access a resource concurrently is defined by the number of rows for this resource in the lock table.
锁表中一个资源的行数决定了可以同时访问这个资源的最大应用程序数量。
Use UPDATE STATISTICS LOW if the number of rows has changed significantly or after migration from previous version of database server.
如果被更改的行数很多,或者刚在不同版本的数据库服务器之间完成迁移,则应使用UPDATESTATISTICSLOW。
The primary purpose of a push-down hash join is to reduce number of rows processed from the fact table, which probes each of the hash tables.
下推散列连接的主要目的是减少处理的事实表行数,这样可以探测每个散列表。
This dynamic filter on the fact table reduces the number of rows used in the probe phase of the actual hash joins.
事实表上的动态过滤减少了实际散列连接探测阶段使用的行数。
The schema is shown in Figure 9, indicating the number of columns and the number of rows in each table after shredding 100,000 of our customer documents.
此模式如图9所示,图9指示了在分解了100,000个客户文档之后,每个表中的列数和行数。
The optimizer bases query cost estimates on the number of rows to be retrieved from each table.
优化器将根据在每个表中检索的行数来评估查询成本。
While the number of rows populating the database schema may have been adjusted to scale, one area remains the same: SQL.
虽然填充数据库模式的行的数量可能被调整到一定规模,但有一个地方仍然是相同的:sql。
When used with collection-based associations, the query can return a different number of rows than would be returned in the default fetching strategy.
在使用基于集合的关联时,查询返回的行数可能与默认抓取策略返回的行数不同。
Set the number of rows to display per page.
设置每个页面上显示的行数。
Note, however, that inlining significantly increases the row size on your data pages. This in turn decreases the number of rows per page.
但是要注意,内联会极大增加数据页面的行大小,从而减少每个页面的行数量。
The amount of virtual Shared memory that the database server allocates for a sort depends on the number of rows to be sorted and the size of the row, and whether PDQPIORIDY is set for the server.
数据库服务器分配给排序的虚拟共享内存的数量取决于要进行排序的行数、每一行的大小以及是否为服务器设置了PDQPIORIDY。
The data designer, by default, shows data for the selected table or view and limits the number of rows to 100.
这个数据设计程序默认情况下显示所选表或视图中的数据,并且最大行数限制为 100。
The query optimizer bases query-cost estimates on the number of rows to be retrieved from each table.
查询优化器根据从每个表检索的行数估计查询成本。
The number of rows entered for each word will be equal to the number of synonyms for that word.
为每个单词输入的行的数量将等于该单词的同义词的数量。