SQL DDL
This topic shows detailed information about Statistics - SQL DDL
.
Statistics - SQL DDL
The field labels shown in the following sample layout of Statistics - SQL DDL
are described in the following section.
SQL DDL QUANTITY /SECOND /THREAD /COMMIT
--------------------------- -------- ------- ------- -------
CREATE TABLE 0.00 0.00 N/C 0.00
CREATE GLOBAL TEMP TABLE 0.00 0.00 N/C 0.00
DECLARE GLOBAL TEMP TABLE 0.00 0.00 N/C 0.00
CREATE AUXILIARY TABLE 0.00 0.00 N/C 0.00
CREATE INDEX 0.00 0.00 N/C 0.00
CREATE VIEW 0.00 0.00 N/C 0.00
CREATE SYNONYM 0.00 0.00 N/C 0.00
CREATE TABLESPACE 0.00 0.00 N/C 0.00
CREATE DATABASE 0.00 0.00 N/C 0.00
CREATE STOGROUP 0.00 0.00 N/C 0.00
CREATE ALIAS 0.00 0.00 N/C 0.00
CREATE DISTINCT TYPE 0.00 0.00 N/C 0.00
CREATE FUNCTION 0.00 0.00 N/C 0.00
CREATE PROCEDURE 0.00 0.00 N/C 0.00
CREATE TRIGGER 0.00 0.00 N/C 0.00
CREATE SEQUENCE 0.00 0.00 N/C 0.00
CREATE ROLE 0.00 0.00 N/C 0.00
CREATE TRUSTED CONTEXT 0.00 0.00 N/C 0.00
CREATE MASK / PERMISSION 0.00 0.00 N/C 0.00
CREATE VARIABLE 0.00 0.00 N/C 0.00
ALTER TABLE 0.00 0.00 N/C 0.00
ALTER INDEX 0.00 0.00 N/C 0.00
ALTER VIEW 0.00 0.00 N/C 0.00
ALTER TABLESPACE 0.00 0.00 N/C 0.00
ALTER DATABASE 0.00 0.00 N/C 0.00
ALTER STOGROUP 0.00 0.00 N/C 0.00
ALTER FUNCTION 0.00 0.00 N/C 0.00
ALTER PROCEDURE 0.00 0.00 N/C 0.00
ALTER SEQUENCE 0.00 0.00 N/C 0.00
ALTER JAR 0.00 0.00 N/C 0.00
ALTER TRUSTED CONTEXT 0.00 0.00 N/C 0.00
ALTER MASK / PERMISSION 0.00 0.00 N/C 0.00
SQL DDL CONTINUED QUANTITY /SECOND /THREAD /COMMIT
--------------------------- -------- ------- ------- -------
DROP TABLE 0.00 0.00 N/C 0.00
DROP INDEX 0.00 0.00 N/C 0.00
DROP VIEW 0.00 0.00 N/C 0.00
DROP SYNONYM 0.00 0.00 N/C 0.00
DROP TABLESPACE 0.00 0.00 N/C 0.00
DROP DATABASE 0.00 0.00 N/C 0.00
DROP STOGROUP 0.00 0.00 N/C 0.00
DROP ALIAS 0.00 0.00 N/C 0.00
DROP PACKAGE 0.00 0.00 N/C 0.00
DROP DISTINCT TYPE 0.00 0.00 N/C 0.00
DROP FUNCTION 0.00 0.00 N/C 0.00
DROP PROCEDURE 0.00 0.00 N/C 0.00
DROP TRIGGER 0.00 0.00 N/C 0.00
DROP SEQUENCE 0.00 0.00 N/C 0.00
DROP ROLE 0.00 0.00 N/C 0.00
DROP TRUSTED CONTEXT 0.00 0.00 N/C 0.00
DROP MASK / PERMISSION 0.00 0.00 N/C 0.00
DROP VARIABLE 0.00 0.00 N/C 0.00
RENAME TABLE 0.00 0.00 N/C 0.00
RENAME INDEX 0.00 0.00 N/C 0.00
TRUNCATE TABLE 0.00 0.00 N/C 0.00
COMMENT ON 0.00 0.00 N/C 0.00
LABEL ON 0.00 0.00 N/C 0.00
TOTAL 0.00 0.00 N/C 0.00
- CREATE TABLE
-
The number of CREATE TABLE statements executed.
Field Name: QXCRTAB
- CREATE GLOBAL TEMP TABLE
-
The number of CREATE GLOBAL TEMPORARY TABLE statements executed.
Field Name: QXCRGTT
- DECLARE GLOBAL TEMP TABLE
-
The number of DECLARE GLOBAL TEMPORARY TABLE statements executed.
Field Name: QXDCLGTT
- CREATE AUXILIARY TABLE
-
The number of CREATE AUXILIARY TABLE statements executed.
Field Name: QXCRATB
- CREATE INDEX
-
The number of CREATE INDEX statements executed.
Field Name: QXCRINX
- CREATE VIEW
-
The number of CREATE VIEW statements executed.
Field Name: QXDEFVU
- CREATE SYNONYM
-
The number of CREATE SYNONYM statements executed.
Field Name: QXCRSYN
- CREATE TABLESPACE
-
The number of CREATE TABLESPACE statements executed.
Field Name: QXCTABS
- CREATE DATABASE
-
The number of CREATE DATABASE statements executed.
Field Name: QXCRDAB
- CREATE STOGROUP
-
The number of CREATE STOGROUP statements executed.
Field Name: QXCRSTG
- CREATE ALIAS
-
The number of CREATE ALIAS statements executed.
Field Name: QXCRALS
- CREATE DISTINCT TYPE
-
The number of CREATE DISTINCT TYPE statements executed.
Field Name: QXCDIST
- CREATE FUNCTION
-
The number of CREATE FUNCTION statements executed.
Field Name: QXCRUDF
- CREATE PROCEDURE
-
The number of CREATE PROCEDURE statements issued.
Field Name: QXCRPRO
- CREATE TRIGGER
-
The number of CREATE TRIGGER statements executed.
Field Name: QXCTRIG
- CREATE SEQUENCE
-
The number of CREATE SEQUENCE statements.
Field Name: QXCRESEQ
- CREATE ROLE
-
The number of CREATE ROLE statements executed.
Field Name: QXCRROL
- CREATE TRUSTED CONTEXT
-
The number of CREATE TRUSTED CONTEXT statements issued.
Field Name: QXCRCTX
- CREATE MASK / PERMISSION
-
The number of CREATE MASK and CREATE PERMISSION statements executed.
Field Name: QXCREMP
- CREATE VARIABLE
-
The number of CREATE VARIABLE statements.
Field Name: QXCRTSV
- ALTER TABLE
-
The number of ALTER TABLE statements executed.
Field Name: QXALTTA
- ALTER INDEX
-
The number of ALTER INDEX statements executed.
Field Name: QXALTIX
- ALTER VIEW
-
The number of ALTER VIEW statements issued.
Field Name: QXALTVW
- ALTER TABLESPACE
-
The number of ALTER TABLESPACE statements executed.
Field Name: QXALTTS
- ALTER DATABASE
-
The number of ALTER DATABASE statements executed.
Field Name: QXALDAB
- ALTER STOGROUP
-
The number of ALTER STOGROUP statements executed.
Field Name: QXALTST
- ALTER FUNCTION
-
The number of ALTER FUNCTION statements executed.
Field Name: QXALUDF
- ALTER PROCEDURE
-
The number of ALTER PROCEDURE statements executed.
Field Name: QXALPRO
- ALTER SEQUENCE
-
The number of ALTER SEQUENCE statements.
Field Name: QXALTSEQ
- ALTER JAR
-
The number of ALTER JAR statements issued.
Field Name: QXALTJR
- ALTER TRUSTED CONTEXT
-
The number of ALTER TRUSTED CONTEXT statements issued.
Field Name: QXALTCTX
- ALTER MASK / PERMISSION
-
The number of ALTER MASK and ALTER PERMISSION statements executed.
Field Name: QXALTMP
- DROP TABLE
-
The number of DROP TABLE statements executed.
Field Name: QXDRPTA
- DROP INDEX
-
The number of DROP INDEX statements executed.
Field Name: QXDRPIX
- DROP VIEW
-
The number of DROP VIEW statements executed.
Field Name: QXDRPVU
- DROP SYNONYM
-
The number of DROP SYNONYM statements executed.
Field Name: QXDRPSY
- DROP TABLESPACE
-
The number of DROP TABLESPACE statements executed.
Field Name: QXDRPTS
- DROP DATABASE
-
The number of DROP DATABASE statements executed.
Field Name: QXDRPDB
- DROP STOGROUP
-
The number of DROP STOGROUP statements executed.
Field Name: QXDRPST
- DROP ALIAS
-
The number of SQL DROP ALIAS statements executed.
Field Name: QXDRPAL
- DROP PACKAGE
-
The number of SQL DROP PACKAGE statements executed.
Field Name: QXDRPPKG
- DROP DISTINCT TYPE
-
The number of DROP DISTINCT TYPE statements executed.
Field Name: QXDDIST
- DROP FUNCTION
-
The number of DROP FUNCTION statements executed.
Field Name: QXDRPFN
- DROP PROCEDURE
-
The number of DROP PROCEDURE statements executed.
Field Name: QXDRPPR
- DROP TRIGGER
-
The number of DROP TRIGGER statements executed.
Field Name: QXDRPTR
- DROP SEQUENCE
-
The number of DROP SEQUENCE statements.
Field Name: QXDROSEQ
- DROP ROLE
-
The number of DROP ROLE statements issued.
Field Name: QXDRPROL
- DROP TRUSTED CONTEXT
-
The number of DROP TRUSTED CONTEXT statements issued.
Field Name: QXDRPCTX
- DROP MASK / PERMISSION
-
The number of DROP MASK and DROP PERMISSION statements executed.
Field Name: QXDRPMP
- DROP VARIABLE
-
The number of DROP VARIABLE statements.
Field Name: QXDRPSV
- RENAME TABLE
-
The number of RENAME TABLE statements executed.
Field Name: QXRNTAB
- RENAME INDEX
-
The number of RENAME INDEX statements issued.
Field Name: QXRNIX
- TRUNCATE TABLE
-
The number of TRUNCATE TABLE statements issued.
Field Name: QXTRTBL
- COMMENT ON
-
The number of COMMENT ON statements executed.
Field Name: QXCMTON
- LABEL ON
-
The number of LABEL ON statements executed.
Field Name: QXLABON
- TOTAL
-
The total number of DDL statements executed.
Field Name: SSCDDL
This is an exception field.