Skip to Main Content
ACE Program
ACE Directory
Become an ACE
ACE Sign In
ACE
Full Name
Jun Ding
Full Name
ACE Pro
Top Level Details
Job Role
Architect
Company
Shanghai New Century Network Tech. Co.Ltd
Country
China, People's Republic of
Top Expertise
Database
Focus Area
Database
About Jun
Jun Ding is a Database Specialist, Over 17 years of experience in Oracle Database about Database system architecture,Performance tuning, Trouble shooting,Administrator etc, Support of Oracle 9i/10g/11g/12c/19c in Production. now focuse on database architecture,Performance tuning,such as Oracle,MySQL,etc. He Published many oracle related white papers:such as Oracle Advanced SQL, PL/SQL development and Main author of Oracle technical book: The Art of Oracle Database Development. Co-sponsor of the DBAPLUS, ACOUG, SOUG community(Oracle User Group in China), Participate in online article contribution and offline salon activities of China's famous IT community. His Blog is http://blog.chinaunix.net/uid/7655508.html
Expertises
Database
Optimization
Database Performance Management
Home Page
http://blog.chinaunix.net/uid/7655508.html
Oracle Community
https://community.oracle.com/tech/developers/profile/Jun%20Ding
Links
Latest Contributions
#SELECTION#
#ICON_HTML#
oracle使用扩展列统计信息解决复杂谓词cardinality估算不准的问题
Apr 26, 2025 - Blog post -
Oracle Database (EE)
Performance
#ACTIONS#
#SELECTION#
#ICON_HTML#
mysql执行计划里索引访问算子和oracle的不同之处
Apr 26, 2025 - Blog post -
Oracle Database (EE)
MySQL 8
Performance
#ACTIONS#
#SELECTION#
#ICON_HTML#
oracle完全存在性判断逻辑
Apr 26, 2025 - Blog post -
Oracle Database (EE)
Performance
#ACTIONS#
#SELECTION#
#ICON_HTML#
Oracle 12c index by rowid batched特性
Apr 26, 2025 - Blog post -
Oracle Database (EE)
Performance
#ACTIONS#
#SELECTION#
#ICON_HTML#
oracle,mysql组合索引前导列范围条件且包含等值条件，可能效率只有范围的更高
Apr 26, 2025 - Blog post -
Oracle Database (EE)
MySQL 8
Performance
#ACTIONS#
#SELECTION#
#ICON_HTML#
MySQL不支持view jppd下推
Apr 26, 2025 - Blog post -
MySQL 8
Performance
#ACTIONS#
#SELECTION#
#ICON_HTML#
oracle非相关子查询处理方式
Apr 26, 2025 - Blog post -
Oracle Database (EE)
Performance
#ACTIONS#
#SELECTION#
#ICON_HTML#
Oracle peeking关闭动态采样导致走错索引
Apr 06, 2025 - Blog post -
Oracle Database (EE)
Performance
#ACTIONS#
#SELECTION#
#ICON_HTML#
oracle 12c开始分页的三种写法及其下推裁剪优化
Apr 06, 2025 - Blog post -
Oracle Database (EE)
Performance
#ACTIONS#
#SELECTION#
#ICON_HTML#
MySQL如何用组合索引提高分页查询执行效率
Apr 06, 2025 - Blog post -
MySQL 8
Performance
#ACTIONS#
#SELECTION#
#ICON_HTML#
MySQL的rows_examined指标缺陷总结
Mar 17, 2025 - Blog post -
Optimization
#ACTIONS#
#SELECTION#
#ICON_HTML#
oracle logical reads(逻辑读)详细分析
Mar 16, 2025 - Blog post -
Optimization
#ACTIONS#
#SELECTION#
#ICON_HTML#
MySQL丢失order by cost计算导致走错索引
Mar 16, 2025 - Blog post -
Optimization
#ACTIONS#
#SELECTION#
#ICON_HTML#
oracle,mysql范围越界的选择率估算
Mar 16, 2025 - Blog post -
Optimization
#ACTIONS#
#SELECTION#
#ICON_HTML#
oracle,mysql,pg的having转换为where规则
Feb 20, 2025 - Blog post -
Oracle Database (EE)
MySQL 8
#ACTIONS#
1 - 15
Next