可保存谓词和不可保留谓词. [英] SARGABLE and NON-SARGABLE Predicates.

问题描述

大家好，

谁能用Examples简要介绍什么是可引用参数和不可引用参数，它对查询的性能起什么作用.


问候
Chaithanya M

Hi Everyone,

Can anyone please brief me what are sargable and nonsargable arguments with Examples.What role it plays on performance of a query.


Regards
Chaithanya M

推荐答案

您可能会找到此 [ ^ ]会有所帮助.

一切都很有趣，但是要搜索有问题的零件的可保存性".

You might find this[^] helps.

It is all quite interesting, but search for ''sargability'' for the part in question.

这篇关于可保存谓词和不可保留谓词.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！