SqlPlus、SecureCRT使用技巧
摘要:
[常用secureCRT映射] select /*+ PARALLEL(a,4) */ * FROM select /*+ parallel(a,4) parallel(b,4) leading(b) use_hash(a,b) */ SELECT /*+ PARALLEL(a,4) */ COUNT(*) FROM WHERE yyyymmdd BETWEEN TO_DATE(20100304, 'yyyymmdd') AND TO_DATE(20100314, 'yyyymmdd') + 86399 / 86400 WHERE yyyymmdd >= 阅读全文
posted @ 2010-11-14 21:42 天晴如许 阅读(1461) 评论(0) 推荐(0) 编辑