index number table 中文意思是什麼
index number table
解釋
計算值診斷表-
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
在數據庫服務器使用所有表篩選器之後，從外部表檢索出的行數將很少，而內部表具有一個可用於執行連接的索引。 -
Number of times the dbcc statement moved from one extent to another while the statement traversed the pages of the table or index
遍歷表或索引的頁時， dbcc語句從一個區移動到另一個區的次數。 -
However, by the time we started collecting index statistics, for example, for the primary key defined on the integer column, there were 10, 000 additional records inserted, hence, the number of rows in the table is 1, 110, 000, and hence the primary index firstkeycard would be 1, 110, 000
但是，在我們開始收集索引統計數據時，例如，對于整型列上所定義的主鍵，就插入了10 ， 000條附加記錄，因此，該表中的行數是1 ， 110 ， 000 ，而主索引firstkeycard將是1 ， 110 ， 000 。 -
In sql server 2005 enterprise edition, the number of processors employed to run a single alter table add index based constraint or drop clustered index constraint statement is determined by the
配置選項和當前工作負荷，確定運行單個alter table add （基於索引） constraint或drop （聚集索引） constraint語句採用的處理器數。 -
In a quick test on a table with 100, 000 rows loaded using a sequence, a normal index was used for most queries returning up to 30 rows, as was the reverse key index, however, when the number of rows went up to 1, 000, 000 the reverse key index was never used and a full table scan was used every time
在一個用一個序列載入並含100 ， 000行的表上做一個快速的測試，分別用普通索引和逆序索引查詢並返回30行數據，當行數增長到1 ， 000 ， 000 ，將不再使用逆序索引而是每次使用全表掃描。 -
Db2 query patroller is also a useful tool in analyzing query history, execution time, and number of hits on each table and index either for tuning the database or administering warehouse usage for cost accounting and chargeback applications
Db2 query patroller在為調整數據庫或管理成本核算和分攤費用應用程序而分析查詢歷史記錄、執行時間以及每個表和索引的命中數方面也是有用的工具。
分享友人