- 博客(3)
- 资源 (2)
- 收藏
- 关注
原创 NATIVE_FULL_OUTER_JOIN
一网友问一sql的优化,语句就不贴了,噼里啪啦一大堆,主要结构是select * from (里面一大堆) a full join ()。看plan就可以了 ----------------------------------------------------------------------------------------------------------------------
2013-10-31 16:32:58 2059 1
原创 索引cost算法初探(接上)
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 Connected as test@192.168.1.118:1521/orcl SQL> SQL> DROP TABLE t PURGE; Table dropped SQL> create table t as select * from dba
2013-10-10 15:13:52 982
原创 全表扫描成本算法初探
学习成本算法并记录如下 Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 Connected as scott@192.168.1.118:1521/orcl SQL> drop table test; Table dropped SQL> create table test as select
2013-10-10 14:12:25 810
Microsoft Jet 参考
2013-07-14
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人