chapter advanced 1 sql programming …（先进1章sql编程u2026）.pdfVIP

Chapter ADVANCED 1 SQL PROGRAMMING TECHNIQUES SYS-ED/ COMPUTER EDUCATION TECHNIQUES, INC. DB2 UDB: App Programming - Advanced Advanced SQL Prg Techniques Objectives You will learn: C Performance factors related to SQL clauses. C Isolation level with specified SQL clauses. C Selecting the appropriate join operation and recognizing the join coding conventions. C Coding joins with nested expressions. C Coding subqueries and correlated subqueries. C Creating and utilizing user defined functions. ® SYS-ED \COMPUTER EDUCATION TECHNIQUES, INC. (DB2/SQL AP PRG: ADV - 3.10) Ch 1: Page i DB2 UDB: App Programming - Advanced Advanced SQL Prg Techniques 1 FOR FETCH ONLY The FOR FETCH ONLY can be specified on the SELECT in a cursor. The cursor cannot be referred to in positioned UPDATE and DELETE statements. Result Tables Some result tables are read-only by nature. In result tables for which updates and deletes are possible, specifying FOR FETCH ONLY may improve the performance of FETCH operations and distributed operations. A read-only result table must not be referred to in an UPDATE or DELETE statement, whether it is read-only by nature or specified as FOR FETCH ONLY. ® SYS-ED \COMPUTER EDUCATION TECHNIQUES, INC. (DB2/SQL AP PRG: ADV - 3.10) Ch 1: Page 1 DB2 UDB: App Programming - Advanced Advanced SQL Prg Techniques 2 OPTIMIZE-FOR-CLAUSE The OPTIMIZE FOR clause requests special