~~NOTOC~~
<WRAP right box>

== Syntax ==
  string expensiveSql()
</WRAP>

===== Description =====

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.

===== Usage =====
<code php>
/*
* 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;
</code>

==== Output ====

{{:v5:performance:performance-expensive-sql.png}}