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）
| 标题 | 阅读 | 评论 | 转发 | 发布日期 | |
|---|---|---|---|---|---|
| 【推荐】 oracle,mysql范围越界的选择率估算 | 341 | 0 | 0 | 2025-03-16 | |
| oracle logical reads(逻辑读)详细分析 | 140 | 0 | 0 | 2025-03-16 | |
| oracle,mysql,pg的having转换为where规则 | 170 | 0 | 0 | 2025-02-20 | |
| 【推荐】 MySQL的RR模式解决不可重复读和幻读了吗？ | 3347 | 0 | 1 | 2025-02-18 | |
| 同时查询min.max索引列，pg,mysql和oracle的区别 | 136 | 0 | 0 | 2025-01-22 | |
| ORACLE分区pruning及其注意点 | 337 | 0 | 0 | 2024-12-01 | |
| oracle,mysql,pg杀会话区别和注意点 | 214 | 0 | 0 | 2024-12-01 | |
| 基于ORACLE的分页查询错误和正确写法 | 261 | 0 | 0 | 2024-12-01 | |
| 【推荐】 ORACLE SQL overlap时间段重叠计算方法 | 15327 | 0 | 0 | 2024-10-29 | |
| oracle用一条语句实现对传入不同条件执行不同分支的技巧 | 396 | 0 | 0 | 2024-10-18 | |
| MySQL row constructor非等值的CBO无法改写为OR，走不了索引 | 475 | 0 | 0 | 2024-08-19 | |
| 【推荐】 ORACLE NOT IN:NULL AWARE ANTI JOIN注意点及其改写 | 39391 | 0 | 0 | 2024-04-07 | |
| 自定义函数索引DETERMINISTIC减少函数调用次数 | 706 | 0 | 0 | 2023-05-09 | |
| 执行计划不共享的原因分析 | 948 | 0 | 0 | 2023-05-09 | |
| Cardinality Feedback特性导致的执行计划改变 | 926 | 0 | 0 | 2023-05-09 | |
| Group By Placement查询转换特性导致SQL执行报错 | 774 | 0 | 0 | 2023-05-09 | |
| 对指定session或sql进行trace的方法 | 853 | 0 | 0 | 2023-05-08 | |
| find implicit conversion sql in oracle | 1533 | 0 | 0 | 2023-05-08 | |
| 【推荐】 使用ORACLE正则表达式 | 9705 | 0 | 0 | 2023-05-08 | |
| 使用索引进行高效分页pagination_PART2 | 829 | 0 | 0 | 2023-05-08 |
吻的感觉适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
