sql的代码优化问题，这里是使用的hql，

Question

select pc from PlasmaCollection pc inner join pc.plasmaPackageDetails detail where pc.state = 'pkg' and pc.plasmaFreeze.freezeId is null

Answer 1

最好pc.plasmaFreeze.freezeId字段有个默认值，比如-1
这样应该会快一点儿