教练在半场时候给球员们打气,希望将他们引上胜利之途。
The coach gave his team a peptalk at half time, hoping to lead them to victory.
您需要知道索引上正在执行多少搜索。
You need to know how many searches are being directed at the indexes.
示例8:只收集所有索引上的目录统计信息。
主键列、外键列和索引上使用的列的数据类型。
Data type of primary key columns, foreign key columns, and columns used on indexes.
这样才能在Lucene索引上运行一次成功的优化。
This is required to run a successful optimization on the Lucene index.
收集索引上的详细抽样统计信息和表的分布统计信息。
Example 28. Collect detailed sampled statistics on indexes as well as distribution statistics for the table.
示例9:收集表和索引上的目录统计信息,包含分布统计信息
Example 9: Collect catalog statistics on the table and indexes with distribution statistics
示例5:收集表和索引上的目录统计信息,不包含分布统计信息。
Example 5: Collect catalog statistics on the table and indexes without distribution statistics.
如果您期望一个索引具有较高的群集因子,就只要重组该索引上的表。
If you expect an index to have a high cluster factor, just reorganize the table on that index.
在employee表和它的新的及剩余的索引上再次收集统计信息。
Statistics are re-collected on the EMPLOYEE table and its new and remaining indexes.
示例7:只收集3个指定索引上的目录统计信息(不含表统计信息)。
Example 7: Collect catalog statistics on 3 specific indexes only (no table statistics).
一次仅在少数表和索引上运行RUNSTATS,在整组表中循环运行。
Run RUNSTATS on only a few tables and indexes at a time, rotating through the set of tables.
目录中不会反映这些修改,除非在这些表和索引上执行RUNSTATS。
None of these changes are reflected in the catalog, unless RUNSTATS is performed on these tables and indexes.
因为该连接是在索引上执行的,所以其成本要低得多,而数据访问则快得多。
Since the join is performed on indexes, the costs are much lower and the speed of accessing data much faster.
必须在表和索引上执行RUNSTATS命令,用最新的信息更新目录表中的列。
A RUNSTATS command has to be performed on tables and indexes so that columns in the catalog tables are updated with the latest information.
最近我发现公司的士气空前低落。您的公司怎么能把我们的事业再引上正轨呢?
Business Owner: Lately I've felt that company morale is at an all-time low what can your firm do to help get my business back on track?
示例10:收集表上的目录统计信息以及索引上的详细统计信息,包含分布统计信息。
Example 10: Collect catalog statistics on the table and enhanced statistics on the indexes, as well as distribution statistics.
示例6:收集表上的目录统计信息以及索引上的详细统计信息,不包含分布统计信息。
Example 6: Collect catalog statistics on the table and enhanced statistics on the indexes, but without distribution statistics.
收集两个索引上的详细目录统计信息,但对每个索引条目使用抽样来代替执行详细的计算。
Example 27. Collect detailed catalog statistics on both indexes, but use sampling instead of performing detailed calculations for each index entry.
这个过程可能比开发者习惯的方式更加手工化一些,但却在数据的索引上给予你更多的灵活性。
This process is probably more hands-on than developers are used to, but it does give you a lot of flexibility on what data is indexed.
示例17:收集所有索引上的目录统计信息,包含列deptname 上的分布统计信息。
Example 17: Collect catalog statistics on all indexes and on column deptname with distribution.
但不要做得太过,不要在只提供微小查询性能好处的索引上浪费宝贵的索引添加资本—您在这里要寻找的是性能大赢家。
Just don't overdo it, and don't waste precious index-add capital on indexes that deliver only marginal query performance benefits-you're looking for the big wins here.
但是,如果会话数据与某个新索引冲突(比如重复行在唯一的索引上冲突),则在数据纠正之前不会为该会话物化该索引。
However, if the session data conflicts with a new index, (such as duplicate rows conflicting with a unique index), the index is not materialized for that session until the data is corrected.
类似于现有的用于关系索引的关系索引扫描操作符(IXSCAN),XISCAN操作符在xml索引上执行查找或扫描。
Like the existing relational index scan operator for relational indexes (IXSCAN), the XISCAN operator performs lookups or scans on XML indexes.
如果创建新的索引,而在最后一次执行RUNSTATS以后还未修改相应的表,那么您可以只收集索引上的目录统计信息。
If new indexes have been created, and the corresponding table has not been modified since the last RUNSTATS execution, then you can collect catalog statistics on indexes only.
存储在Tonido应用程序上的数据不会出现在搜索引擎的索引上;对很多个人和企业(比如我)来说,这算不上什么好处。
Data stored on Tonido apps isn't indexed by search engines; for many people and entities, such as myself, this is hardly a benefit.
存储在Tonido应用程序上的数据不会出现在搜索引擎的索引上;对很多个人和企业(比如我)来说,这算不上什么好处。
Data stored on Tonido apps isn't indexed by search engines; for many people and entities, such as myself, this is hardly a benefit.
应用推荐