oracle sequence 是否需要顺序？
发布时间：2020-12-12 15:38:14 所属栏目：百科 来源：网络整理
导读：The ORDER clause is a performance killer for sequences in Oracle RAC. This clause will guarantee that the NEXTVAL is in order from the previous value no matter which instance is asking for the next value. For an active sequence,this means
|
The ORDER clause is a performance killer for sequences in Oracle RAC. This clause will guarantee that the NEXTVAL is in order from the previous value no matter which instance is asking for the next value. For an active sequence,this means there will be lots of chatter on the Cluster Interconnect. Also,if you use ORDER,then it is worse than NOCACHE (another performance killer for active sequences in Oracle RAC). （编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |