摘要：When we use in and not in, it will take a long time to get the results. because it scans all the records of the table. we can use left join instead of in or not in like the following:1. select * from table1 where tabel1.name not in (select name from table2)is equals toselect a.* from table1 aleft jo 阅读全文

摘要：最近开始在项目中使用oracle数据库，针对项目中的大数据量搜索效率变得奇慢无比，学习采用分页方式来解决，综合网上的资料最终搞定。oracle存储过程需要写在包里，代码如下：包定义：[代码]包体定义：REATE OR REPLACE PACKAGE Body DotNet is --**********************************************************... 阅读全文