gpt4 book ai didi

sql - 案例与解码

转载 作者:行者123 更新时间:2023-12-03 07:52:34 26 4
gpt4 key购买 nike

引用以前的question ,我想知道它是否总是可以替换 解码 来自 案例 哪个性能更好?

最佳答案

一如既往地使用 Oracle ... AskTom ...

从这里 post ...

Decode is somewhat obscure -- CASE is very very clear. Things that are easy to do in decode are easy to do in CASE, things that are hard or near impossible to do with decode are easy to do in CASE. CASE, logic wise, wins hands down.



从性能的角度来看,它们似乎大致相同,上面的文章再次提到了一些速度差异,但没有对特定语句进行基准测试就很难说。

关于sql - 案例与解码,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/3193692/

26 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com