Performance

A idéia desta seção é disponibilizar, e atualizar sempre que possível, com dicas, links e documentos para auxiliar na arte de "tunar" a instância Informix. Algumas dicas veêm de grupos como o NART (North America Resolution Team) e/ou APD (Advanced Problem Diagnostics), e outras até mesmo de R&D (Research and Development).

Performance Tuning Tips for IBM Informix Dynamic Server
http://informix-zone.com/files/whitepapers/perf-tuning-tips.pdf

Informix Performance Tuning Webcast (by Art Kagel - Advanced Data Tools)
http://www.advancedatatools.com/Informix/InformixPerformanceTuning-ArtKagel_webcast1.pdf
http://www.advancedatatools.com/Informix/InformixPerformanceTuning-ArtKagel_webcast2.pdf
http://www.advancedatatools.com/Informix/InformixPerformanceTuning-Artkagel_webcast3.pdf

Understanding and Tuning Update Statistics
http://www.ibm.com/developerworks/data/zones/informix/library/techarticle/miller/0203miller.html

Get the most out of Informix Dynamic Server optimizer through UPDATE STATISTICS
http://www.ibm.com/developerworks/data/library/techarticle/dm-0803changappa/

Take advantage of fragment-level statistics and smarter statistics in IBM Informix
http://www.ibm.com/developerworks/data/library/techarticle/dm-1104fragmentstats/index.html

Optimizing Informix database access
http://www.ibm.com/developerworks/data/library/techarticle/dm-1203optimizeinformix/index.html

Informix DBA: Every last drop
http://www.ibm.com/developerworks/data/library/dmmag/DMMag_2011_Issue4/InformixDBA/index.html

Part 1: Tuning Informix SQL
http://www.ibm.com/developerworks/data/library/techarticle/dm-0409fan/

Part 2: Tuning Informix SQL
http://www.ibm.com/developerworks/data/library/techarticle/dm-0410fan/

Tune your Informix database for top performance, Part 1: Tuning the data model and the application
http://www.ibm.com/developerworks/data/library/techarticle/dm-1104tuneinformix1/index.html?ca=drs-

Tuning Informix DSS queries
http://www3.software.ibm.com/ibmdl/pub/software/dw/dm/db2/dm-0205parker/part-1.pdf

Informix DBA: Fastest Informix DBA contest III
http://www.ibm.com/developerworks/data/library/dmmag/DMMag_2011_Issue2/InformixDBA/index.html

SQL Statement Cache in Informix Dynamic Server
http://www.ibm.com/developerworks/data/library/techarticle/0310iyer/0310iyer.html

Non-blocking checkpoints in Informix Dynamic Server
http://www.ibm.com/developerworks/data/library/techarticle/dm-0703lashley/

FFO