No indexes exist at this time.
此时,不存在任何索引。
不需要索引。
However, if no indexes are available, the query optimizer must use a table scan.
但如果没有索引,则查询优化器必须扫描表。
There are no indexes on these tables for DB2 to consider using during the execution of the query.
这些表上没有在执行查询期间DB 2可用的索引。
It is used when there are no indexes on one or more joining tables, or when the database server must read a large number of rows from all joining tables.
当一个或多个连接表上没有索引时,或者当数据库服务器必须从所有连接表中读取大量行时,就使用这种方法。
Figure 7 shows the query response times as a function of the number of documents in the table, ranging from 1,000 to 100,000 documents (when no indexes or side tables are used).
图7显示查询响应时间作为表中文档数(范围从1,000到100,000)的函数(不使用索引或索引表)。
First analyze the access plan that the optimizer chooses when no distribution statistics are available, which is only basic statistics for the table CARS, and that its indexes exist.
首先来分析一下,在没有分布统计信息,而只有cars表的基本统计信息及其索引的情况下,优化器选择的访问计划是怎样的。
Note: Disabling the feature should be done before dropping all indexes and if desired, revoking permissions of the user account, so that no user errors will result.
注意:使功能失效要在删除所有索引之前进行,如果需要可以取消用户帐户权限,这样就不会导致用户的错误。
For instance, did you notice that there were no single quotes around the array indexes ($x[sales] and $x[profit])?
比如,你有没有发现在数组索引里没有用引号将字符串括起来?
The index elements can optionally specify two or more indexes that will be used in the 'IXAND' plan in the specified order and no additional indexes will be added by the optimizer to the IXAND.
INDEX元素可以选择性地指定两个或更多索引,它们将按照指定的顺序应用到“IXAND”计划中,并且优化器不会向IXAND添加更多的索引。
The following examples illustrate partition-level REORG on a table that has no global indexes.
以下例子阐明了如何在不含全局索引的表上应用分区级别reorg ?
LevelDB has some limitations: no support for SQL queries or indexes, supports multi-threaded single process access and is embedded, which is an advantage for some projects and a problem for others.
LevelDB也有一些局限:不支持SQL查询和索引,支持多线程单进程访问,并且可以用于嵌入式设备,这将使某些项目收益,但是也会给其他的项目来带麻烦。
An IXAND plan such that the specified XML indexes are used in the specified order but no additional indexes are included.
一个IXAND计划,将按照特定的顺序使用指定的xml索引,并且没有包含任何额外的索引。
Example 7: Collect catalog statistics on 3 specific indexes only (no table statistics).
示例7:只收集3个指定索引上的目录统计信息(不含表统计信息)。
Covered indexes enhance performance when all fields requested by a query are contained within the covered index because there is no need to pull up the full document record.
Covered索引在查询所请求的全部字段都包含在Covered索引中时能提升性能,因为不再需要取出完整的文档记录。
Merging the autogenerated indexes into an already deployed application is also a potentially error-prone process with no indication of error until web application users hit the misconfigured indexes.
将自动生成的索引合并到已经部署的应用程序中也是一个潜在的容易出错的过程,该过程直到web 应用程序用户点击错误配置的索引前都没有错误提示。
It taxes the system while it indexes and has no integration with existing desktop applications.
在它索引的时候它降低系统的性能,和现有的桌面应用没有整合。
If you no longer want to enable case-insensitive queries on any field in the table, you can disable indexes for the entire table.
如果您不再想在这个表格的任何一个域上激活不能区分大小写查询程序,您可以使整个表格的索引功能失效。
By leveraging local indexes, roll-in not only makes the newly attached data visible more quickly, but consumes virtually no active log space.
借助本地索引功能,滚入操作使得新附加的数据更快可见,并且不会耗费活动日志空间。
Making matters worse, GAE provides no easy way to delete indexes that are no longer in use.
更糟的是,GAE没有提供简单的方式来删除不再使用的索引。
There are no functional indexes defined at this time.
这次没有定义函数索引。
In DB2 9.5, automatic dictionary creation was added so you no longer had to deal with building a dictionary yourself; in DB2 9.7, indexes and temporary tables can now be compressed.
在DB 2 9.5中,添加了自动字典创建,所以不再需要自行构建字典;在DB 2 9.7中,索引和临时表现在可以压缩。
L 700: This specifies that any new indexes, MQTs, and so on should consume no more than 700 MB.
l 700:规定任何新的索引、MQT等都不能消耗多于700 MB的空间。
CONCLUSIONS: There were no significant differences in quality indexes between the domestic valsartan capsule and the imported one.
结论:国产与进口缬沙坦胶囊的各项质量指标均无明显差异。
Reorg index - For example, reorg indexes all for table <Schema Name>.