Oracle Performance tuning – Bitmap Index and usage – simple introduction.
Posted by
Jiltin 13 March, 2009 2,560 views
- Oracle scripts – Tuning & Performance – Gather Statistics importance
- Wordpress – Mysql Performance tuner, a free Good Optimizer
- XCACHE – The Great PHP opcode Performance Tool For Wordpress Bloggers
- How to improve or tune oracle scripts performance – Case History and issues from oracle applications?
- MYSQL : Tuning / Optimizing my.cnf file
Performance tuning cannot be performed optimally after a system is put into production. To achieve performance targets of response time, throughput, and constraints you must tune analysis, design, and implementation. Goals for tuning vary, depending on the needs of the application. Online transaction processing (OLTP) applications define performance in terms of throughput.
One of the important aspect is to use indexing the table used in query. In this section, I describe the importance of bitmap indexing and how that improves query performance.
Categories :
Web Blog!
Comments
No comments yet.