Database index is critical to query performance.
数据库索引对于查询性能来说十分关键。
As mentioned before, a database index is critical to performance.
正如上面所提到的那样,数据库索引对性能来说十分关键。
The most common in-memory database index strategy is called T-tree.
最常见的内存中数据库索引策略是T -树。
This check requires that a database index for the attribute CSCDISIS is configured in CM.
这种检查要求在CM中配置CSCDISIS属性的一个数据库索引。
Spatial database index is the vital technique for improving the storage efficiency of spatial databases and the spatial retrieval performance.
空间数据库的索引是提高空间数据库存储效率、空间检索性能的关键技术。
This paper classify a series of methods on spatial database index, and introduce the QR-tree index structure with very large spatial database.
在综述现有空间数据库索引技术的基础上,提出了一种面向大型空间数据库的QR-树索引方法。
We started with a blind placement strategy of putting the database index files on SSD storage, but that generated only a modest improvement (less than 2x).
首先采取随意安排的策略将数据库索引文件放到SSD存储上,但是这样做只获得不多的性能提升(不超过2倍)。
Note: the Digest Search 2 database (Digest2.nsf) includes an agent called Process database index that creates an index for the documents from the source database.
注意:DigestSearch2数据库(Digest2 . nsf)包含一个称作processdatabase index的代理,用于为源数据库中的文档创建索引。
Because you can't create a composite database index using columns across the super and a subclass, the performance will suffer if you need to query on such columns.
因为不能跨超类和子类的字段来建立复合索引,如果需要按这些列进行查询,性能会受影响。
If users are allowed to search their archived mail, the fields CSLDOrigDB and main search criteria (like the Subject attribute) should also have a database index configured.
如果用户被允许搜索已归档的邮件,那么也应该为字段CSLDOrigDB和主要的搜索标准(如subject属性)配置数据库索引。
This paper has introduced the design methodology of main memory, database index in fire monitoring system, and compared the system running efficiency in these two situations.
本文介绍了消防监控系统中内存数据库索引的设计方法,并对比了两种方法下的系统运行效率。
By the research of database index, A new and efficient database index built by multi-dimension linked lists is given out , and also main problems of the database index are discussed there.
通过对多维链表的研究,提出一种全新的、基于多维链表的、可以同时在多个属性上建立高效数据库索引的方法,并对这种索引方法的主要问题进行了比较详细的讨论。
If the database designer has created a Primary partition Index on a table, queries should incorporate the partitioning column.
如果数据库设计者已在表上创建了主分区索引,那么查询应当与分区列结合。
This makes DB2 queries use table scans instead of index scans and degrades database performance.
这使得DB 2查询使用表扫描代替索引扫描,并降低了数据库的性能。
Database performance plummets once index tables don't fit in memory anymore, so scale up memory as far as possible to hold tables.
一旦索引表再也无法装入内存,数据库的性能就会直线下降,所以应该尽量升级内存,以便存放那些表。
A buffer pool is an area of storage in memory into which database pages (containing table rows or index entries) are temporarily read and changed.
缓冲池是内存中的一块存储区域,用于临时读入和更改数据库页(包含表行或索引项)。
If all the columns in the clause appear in the required sequence with a single index, the database server USES the index to read the rows in the ordered sequence, thus avoiding a sort.
如果该子句中所有的列都是以用单个索引要求的顺序出现的,那么数据库服务器就使用索引来按顺序读取行,因而避免了排序。
Physical database design includes table design, index design, materialized query table design, and the design of the other physical database objects.
物理数据库设计包括表设计、索引设计、物化查询表设计,以及其他物理数据库对象的设计。
The agent that updates the index database with new documents is currently rather slow and is not optimized, which can be fixed by adding a couple of tracking fields to the index documents.
使用新文档更新索引数据库的代理目前速度很慢,且未进行优化,通过添加一对跟踪字段到索引文档中就可以解决这一问题。
Develop a server add-on that automatically adds new and modified documents from the source database to the index database.
开发一个服务器附件,自动将新的和修改了的文档从源数据库添加到索引数据库。
Summary: Adding an index to a DB2 database is often the best way to improve query performance, but the addition can have trade-offs.
简介:向DB 2数据库添加索引通常是改善查询性能的最好方法,但添加索引也是有代价的。
The columns in the WHERE clause decide what index the database will select.
WHERE子句中的字段决定了数据库将选择的索引。
That results in a database selection wizard, wherein you allowed to choose the database where you want to perform various checks, namely database, data, index, logs, and space checks.
这会打开数据库选择向导,可以在此向导中选择要执行各种检查的数据库,比如数据库、数据、索引、日志和空间检查。
In 1996, WHO set up a global database on obesity and body mass index, the common measure of fatness.
1996年,世界卫生组织建立了一个肥胖和身体质量指数数据库,身体质量指数是衡量肥胖的通行标准。
A database requiring an index that large is extreme and creates significant problems related to performance and database administration.
需要那么多索引的数据库的确称得上超大,这种数据库的性能和数据库管理是个很大的问题。
Now that the view injects the filter predicate at the SQL level, DB2 can take advantage of the usual database techniques, that is index access.
现在,该视图在sql级注入过滤谓词,DB 2可以利用通常的数据库技术,即索引访问。
There are three main ways to update the Demo Index database with new documents.
可以通过以下三种主要方式,使用新文档更新DemoIndex数据库。
Initialize the index database and all the MKF databases (includes permanent, transient, and security databases). Enter the following commands to initialize the databases.
初始化索引数据库和所有MKF数据库(包括永久、临时和安全数据库)。
After you have configured the paths to the databases, you must populate the index database with information from the Demo NAB.
为数据库配置了路径后,必须使用来自DemoNAB的信息填充索引数据库。
Although Lucene is a search index, and not a database, if your fields are reasonably small, you can ask Lucene to store them in the index.
虽然Lucene是一个搜索索引而非一个数据库,但是如果这个字段相当小,你可以让Lucene把它们存在索引里面。
应用推荐