oracle数字存储的性能对比
NUMBER vs BINARY_FLOAT/BINARY_DOUBLEPerformance ConsiderationsIn general, the Oracle NUMBER type is the best overall choice for most applications. However, there are performance implicati...
exists/in 在oracle中的执行效率-浅谈
oracle version : 10.2.0.1SQL> SQL> select * from cui2 2 where exists (select 1 from t where t.id=cui2.id and t.pad is not null) 3 ;已选择1100行。执行计划--------------------...