顺序很重要,如果你的谓语以不同的顺序指定这些属性或在它们前罗列了其他属性,数据库就不会选择该复合索引。
The order is important because if your predicate specifies these properties in a different order or lists some other property before them, the composite index will not be selected by the database.
但是,如果没有数据分布,则数据库服务器根据表索引计算不同类型的过滤器的选择率。
However, in the absence of data distributions, the database server calculates selectivity for filters of different types based on table indexes.
对于要由层次体系中具有不同权限级别的用户所访问和编辑的数据,某种形式的数据库是惟一的选择。
For data that is accessed and edited by many different users with varying levels of privilege across heterogeneous systems, a database of some kind is the only option.
现在,当同一个查询运行时,生成的原生sQL是单个选择语句,在语句在数据库层联接来自不同目录的两个表,如图10所示。
Now, when the same query is run, the native SQL that is generated is a single select statement joining the two tables from the different catalogs at the database tier as shown in Illustration 10.
DB 2V8.2.2增加了用一个不同于4KB的初始页面大小(您可以选择DB 2所支持的任何页面大小)创建数据库的能力。
DB2 V8.2.2 adds the ability to create a database with an initial page size other than 4 KB (you can choose any page size that DB2 supports).
然而WebSphereApplicationServer中不同的访问意图策略将会为所支持的数据库选择一个合适的隔离级,为开发人员减轻了该细节上的不少麻烦。
However each access intent policy in WebSphere Application Server will choose an appropriate isolation level for supported databases, relieving the developer from this level of detail.
该脚本可以得到进一步的改进,以实施其他的变量,例如对于不同用户数据库的不同选择列表,根据用户数据库而变的许可权限等等。
This script can be further enhanced to implement other variations, such as different choice lists for different user databases, permissions according to the user databases, and so forth.
有很多不同的方法实现这一情况,但关系数据库是最常用的选择。
There are a lot of different ways of achieving this, but relational databases remain the most common choice.
正如我所说的那样,与通常的关系数据库相比,db4o可以提供更多的方法来进行查询,为您处理不同应用程序场景提供了更多选择。
As I showed, db4o offers quite a few more ways to query than your typical relational database can, giving you a range of options for dealing with various application scenarios.
通过选择参考脸和最相似人脸的数目,可大致控制不同规模数据库的识别时间。
Through selecting the number of reference faces and the mostly expected similar face set, the recognition time for different scales of databases can be controlled approximately.
目前,虽然已能获得一些诊断性研究的检索策略,但仍应考虑针对不同的数据库选择检索词和制定检索策略。
Although some search strategies can be used to identify diagnostic studies, specific search terms and strategies aimed at different databases should also be considered.
目前,虽然已能获得一些诊断性研究的检索策略,但仍应考虑针对不同的数据库选择检索词和制定检索策略。
Although some search strategies can be used to identify diagnostic studies, specific search terms and strategies aimed at different databases should also be considered.
应用推荐