kyle HaileyJun 5, 20091 minFinding the problem is the hard partInteresting blog on how finding performance problems takes 80% of the mean time to resolution. Sybase ASE Performance and Tuning This is...
kyle HaileyJun 4, 20091 minTypes of subqueriesTypes of subqueries (today I couldn’t think of the term “inline view”) subquery ( subselect used in where clause) correlated subquery...
kyle HaileyJun 4, 20091 minStephen Faroult on Tuning SQLOne of the main things I do to tune SQL is to encourage the optimizer to take path. I often take the most important steps to do first and...
kyle HaileyJun 1, 20091 minCorrelating SQL to ProceduresStarting in Oracle 10.2.0.3 (ie not 10.2.0.2 and below) it’s easy to track what package and/or procedure a SQL execution came from using...