通过为联接两端的字段以及用于设置查询条件的字段创建索引,可以极大地提高查询的速度。
You can make dramatic improvements in the speed of a query by indexing fields that are on both sides of joins, and fields that are used to set criteria for the query.
如果希望获取满足查询条件的所有结果,就不要设置这些属性。
If you want to retrieve all the results that satisfy the query criteria, do not set these properties.
当通过在查询中设置更多谓词来提供更详细的搜索条件时,优化器就有机会作出更好的选择。
When you provide more detailed search conditions by having more predicates in a query, the optimizer has a chance to make better choices.
应用推荐