Tags

, , , , , , , ,

Predicates that we commonly use are Equality operators (=, <>, >, <, …), BETWEEN, IN, NOT, LIKE, EXIST and many more. Do you know that there is a processing order for each predicate. That is, at what stage of the SQL Query execution, particular predicate is applied.

Predicates are applied by stage in the following order:

  1. Indexable predicates that match on index key columns are applied and evaluated when the index is accessed.
  2. Stage 1 index screening predicates that have not been picked as index matching predicates but still refer to index columns, are applied to the index.
  3. Stage 1 page range screening predicates refer to partitioning columns are applied to limit the number of partitions that are accessed.
  4. Other stage 1 predicates are applied to the data, after data page access.
  5. The stage 2 predicates are applied on the returned data rows.

And list of all predicates and above information can be found at the IBM link

http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/perf/src/tpc/db2z_summarypredicateprocessing.html

——————————————————————————————————–

In United States, If you would like to Earn Free Stocks, Credit card Points and Bank account Bonuses, Please visit My Finance Blog

——————————————————————————————————–

You may also like to look at:

Working on Mainframes – Is Change to a different technology necessary
Important SQL CODES and ABEND CODES
SORT JOIN – TO JOIN TWO FILES BASED ON A KEY
KNOW YOUR MAINFRAME
REXX – INITIAL SETUP
HOW TO SUBMIT A BATCH JOB FROM THE CICS PROGRAM
CICS – EXEC interface block – EIBRESP Values
CICS – EXEC interface block Fields
Flow of control between COBOL programs, run units, and CICS
CICS INTERVIEW QUESTIONS
CICS TIPS
COBOL – COPY and INCLUDE statements
COBOL – PERFORMANCE IMPROVEMENT
COBOL – SIGN STORED IN COMP, COMP-3 AND DISPLAY FORMATS
SHORTEST COBOL PROGRAM
RESTART LOGIC IN COBOL DB2 Program
GOBACK – EXIT PROGRAM – STOP RUN
Continuation lines in COBOL
Computational items – COMP, COMP 1 , COMP 2, COMP 3
COBOL program format
cobol indicator area column-7 and area a and area b
COBOL INTERVIEW QUESTIONS
COBOL TIPS
COBOL COMPILER OPTIONS
The IDENTIFICATION DIVISION