At times it may be helpful to exclude SQL statements from the Ignite performance data collection module, e.g. exclude SQL statements associated with backups, replication, etc.  To do this, go to the 'Database Query Tool' from the 'Options' menu on the main Ignite screen. You will need the Ignite ID for the database instance you are working with and the Ignite ID for the SQL statement that you want to exclude.

Ignite Database/Instance ID

select ID, name from cond;

Copy and paste the ID value into the INSERT statement below replacing the <DBID> placeholder.

Ignite ID for SQL Statement

From within the Ignite GUI, click on the SQL statement where it appears in any of the legends.  You will see the SQL text along with the ID (Hash) for the statement.  Copy and paste that number into the INSERT statement below replacing the <SQL Hash> placeholder.

INSERT the SQL into CON_QP_EXCLUDE (prior to 8.1)

INSERT INTO con_qp_exclude (dbid, type, value) VALUES (<DBID>, 'H', '<SQL Hash>');

INSERT the SQL into CON_QP_EXCLUDE (8.1 and after)

INSERT INTO con_qp_exclude (dbid, type, value, origin) VALUES (<DBID>, 'H', '<SQL Hash>', 'U');

All future data collection will exclude this SQL statement.  No past data will be purged up as a result, but the SQL statement will eventually age out of all charts in the Ignite GUI.