The function expensiveSql() returns a list of SQL statements with very high execution times collected by the performance monitor logSql feature, formatted as an HTML table.

/*
* Connection to DB2 database
*/
 
$perf = newPerfMonitor($db);
 
/*
 * Enable logging
*/
$db->logSql();
 
/*
 * Execute expensive SQL statement
*/
$SQL = "SELECT * FROM act where actno > 200";
 
$db->execute($SQL);
 
 
$h = $perf->expensiveSql();
 
print $h;