摘要:
import java.util.concurrent.TimeUnit; import java.util.concurrent.atomic.AtomicReference; import java.util.concurrent.atomic.AtomicStampedReference; p 阅读全文
摘要:
select parent_id,F_id,F_name,level from risk_ver where level=2 start with parent_id='0' connect by prior f_id=parent_id order siblings by f_id 阅读全文
摘要:
三大表连接: 1.Nested Loops Join (偏局部扫描的OLTP应用) 2.Hash Join 3.Merge Sort Join 和 Hash Join 偏OLAP应用 表的访问次数之NL连接研究 /* 结论: NL连接中,驱动表被访问0或者1次,被驱动表被访问0次或者N次,N由驱动表 阅读全文