About me:Oracle ACE pro,optimistic,passionate and harmonious. Focus on ORACLE,MySQL and other database programming,peformance tuning,db design, j2ee,Linux/AIX,Architecture tech,etc
全部博文（191）
| 标题 | 阅读 | 评论 | 转发 | 发布日期 | |
|---|---|---|---|---|---|
| mysql执行计划里索引访问算子和oracle的不同之处 | 80 | 0 | 0 | 2025-04-26 | |
| 【推荐】 MySQL不支持view jppd下推 | 424 | 0 | 0 | 2025-04-26 | |
| oracle非相关子查询处理方式 | 98 | 0 | 0 | 2025-04-26 | |
| Oracle 12c index by rowid batched特性 | 103 | 0 | 0 | 2025-04-26 | |
| oracle使用扩展列统计信息解决复杂谓词cardinality估算不准的问题 | 103 | 0 | 0 | 2025-04-26 | |
| oracle完全存在性判断逻辑 | 64 | 0 | 0 | 2025-04-26 | |
| oracle,mysql组合索引前导列范围条件且包含等值条件，可能效率只有范围的更高 | 122 | 0 | 0 | 2025-04-26 | |
| oracle 12c开始分页的三种写法及其下推裁剪优化 | 53 | 0 | 0 | 2025-04-06 | |
| MySQL如何用组合索引提高分页查询执行效率 | 82 | 0 | 0 | 2025-04-06 | |
| Oracle peeking关闭动态采样导致走错索引 | 74 | 0 | 0 | 2025-04-06 | |
| MySQL的rows_examined指标缺陷总结 | 221 | 0 | 0 | 2025-03-17 | |
| MySQL丢失order by cost计算导致走错索引 | 138 | 0 | 0 | 2025-03-16 | |
| 【推荐】 oracle,mysql范围越界的选择率估算 | 443 | 0 | 0 | 2025-03-16 | |
| oracle logical reads(逻辑读)详细分析 | 145 | 0 | 0 | 2025-03-16 | |
| oracle,mysql,pg的having转换为where规则 | 173 | 0 | 0 | 2025-02-20 | |
| 【推荐】 MySQL的RR模式解决不可重复读和幻读了吗？ | 3427 | 0 | 1 | 2025-02-18 | |
| 同时查询min.max索引列，pg,mysql和oracle的区别 | 143 | 0 | 0 | 2025-01-22 |
吻的感觉适2025-07-18 23:11
https://txc.qq.com/products/762795/blog/2019636
https://txc.qq.com/products/762801/blog/2019637
https://txc.qq.com/products/762763/blog/2019638
https://txc.qq.com/products/762772/blog/2019639
https://txc.qq.com/products/762790/blog/2019641
https://txc.qq.com/products/762758/blog/2019640
https://txc.qq.com/products/762786/blog/2019642
https://txc.qq.com/products/762782/blog/2019643
https://txc.qq.com/products/762757/blog/2019644
https://txc.qq.com/products/762805/blog/2019645
https://txc.qq.com/products/762785/blog/2019647
https://txc.qq.com/products/762815/blog/2019646
https://txc.qq.com/products/762787/blog/2019648
https://txc.qq.com/products/762799/blog/2019649
https://txc.qq.com/products/762775/blog/2019650
https://txc.qq.com/products/762759/blog/2019651
https://txc.qq.com/products/762770/blog/2019652
https://txc.qq.com/products/762855/blog/2019654
