SQL Statements Grouped by Source
The source type of an SQL statement is the area of USoft Developer that this SQL statement is related to. A source type is one of the following:
For SQL statements, the source type and source depend on the internal reason why the SQL Statement is executed. They will be calculated when saving a profile.
If a constraint causes the execution of an SQL statement, then the source type is Constraint. The same holds for the following source types (in which case, the source for the SQL statement is the name of the source that causes the execution of this SQL statement):
If the internal Reason for an SQL statement is MANIPULATION or SEQNO, then the source type is System. If the internal Reason is AUTHORIZATION, then the source type is Authorization. In all other cases, the source type is Interface.
The SQL Statements Grouped by Source tab page on the Test Profiles window shows grouped information about the source types and sources that cause SQL statements to be executed. The advantage of this grouped information is that it gives a clear view of which source type and source causes performance problems.
The SQL Statement sGrouped by Source tab page
You can click the SQL Statements button to view the SQL statements within this source.