Appendix B. DB2 SQL Terminology
Every DB2 application requires three components to operate: the system, the database, and the application itself. The system refers to the DB2 subsystem installation, the database refers to the database objects that house the application data, and the application is the host language and SQL code that process the data for the users. To effectively deliver good DB2 performance, system programmers, database analysts, and developers must be able to monitor and tune each of these components.
Cardinality
Cardinality usually refers to a column and the number of distinct values for that column across all rows of data in a table. For example, say that the EMP table has 42 rows where there are 42 different values for the ...
Get DB2 SQL Tuning Tips for z/OS Developers now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
