- 最后登录
- 2023-8-16
- 在线时间
- 1686 小时
- 威望
- 2135
- 金钱
- 50532
- 注册时间
- 2011-10-12
- 阅读权限
- 200
- 帖子
- 5207
- 精华
- 39
- 积分
- 2135
- UID
- 2
|
1#
发表于 2011-12-16 22:15:52
|
查看: 3829 |
回复: 1
Designing for Oracle
• Changes over time
• CPU
• IO
• Networks
• BUT Designing and Tuning, Large High Performance
systems is NOT about tips and tricks, or fashion
• It is about good engineering practice
Database Performance Basics
Schemas and SQL Statements
• Good schema/data design is the foundation to good
database performance.
• Good schema/data design makes downstream
activities both simpler and less error prone
• Selection of Index and Partitioning Columns
• Gathering and maintenance of schema statistics
• Writing correct SQL statements
• Optimization of SQL statements
• Avoidance of serialization points and transactional
bottlenecks
4.Zos.pdf
(922.82 KB, 下载次数: 13, 售价: 5 金钱)
|
|