DB2 Developers Guide (5th Edition)
| < Day Day Up > |
| [SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] [Z]
GBPCACHE parameter GBPDEP parameter buffer pools GDG image copies relative generation numbers GDGLIMIT option TEMPLATE statement Generalized Trace Facility. GENERATE_UNIQUE function generate_unique() UDFs GENERATED parameter identity columns GETDIAGNOSTICS statement application programs 2nd 3rd 4th 5th combined information condition information 2nd connection information 2nd statement information 2nd GETHINT function GetInstruments UDF audio GetTrackNames UDF audio GETVARIABLE function global data buffering 2nd buffer pools group buffer pool duplexing 2nd updating/reading data 2nd global locking management CF 2nd global locks 2nd structures global traces 2nd 3rd GoldenGate Software Inc. Google Web site governing predictive RLF 2nd reactive RLF governors QMF 2nd 3rd RLF predictive governing reactive governing RLSTs 2nd 3rd 4th 5th 6th 7th GRANT statements privileges 2nd granting authorities public display SELECT privileges 2nd public access 2nd grants security 2nd granularity triggers 2nd GRAPHIC data type promotability GRAPHIC function GREATEST function GRECP status (Group buffer pool recovery pending) GROP MEMBER column DSN STATEMENT TABLE GROUP ATTACH name group attach processing DSN commands group authorities group buffer pool duplexing 2nd 3rd 4th Group buffer pool recovery pending (GRECP) status GROUP BY clause columns ORDER BY clause, compared GROUP MEMBER column PLAN TABLE GROUP parameter DSN commands group-level authorizations group-level names data sharing group-level security GROUP_MEMBER column DSN_FUNCTION_TABLE table grouping buffer pools columns data 2nd like programs transactions CICS groups data sharing 2nd creating global locks 2nd 3rd hierarchical locks L-locks monitoring 2nd P-locks MVS performance TSO repeating denormalization 2nd storage 2nd buffer pools default defining 2nd 3rd disk volumes navigational queries SMS 2nd 3rd 4th user -defined VSAM data sets 2nd 3rd volumes, assigning GSE U.K. DB2 Working Group Web site GTF (Generalized Trace Facility) GUI workstations online performance monitoring guidelines (SQL) complex statements Cartesian products clustered columns columns order 2nd columns, grouping denormalization exception reporting existence tests 2nd explicit inner joins explicit outer joins flexibility IN lists duplicates IN lists, ordering indexed columns join rows join table limits 2nd 3rd joins 2nd joins vs subqueries 2nd left outer joins multi-row fetches outer join nulls 2nd outer join predicates 2nd predicate transitive closure 2nd result sets, limiting 2nd row expressions 2nd rows, counting scalar fullselects search criteria sorting joins subqueries subquery negation logic table expressions 2nd 3rd 4th 5th 6th 7th Top Ten 2nd unions 2nd simple statements access paths, customizing analysis tools arithmetic expressions 2nd 3rd automatic rebinds BETWEEN predicate built-in functions 2nd column expressions 2nd data sharing auto rebind data, limiting date and time arithmetic 2nd decimal precision/scale distributed query blocks dummy tables duplicate rows, deleting 2nd embedded SQL, pretesting equivalent data types 2nd EXPLAIN command 2nd FOR READ ONLY clause function tables host variables 2nd IN predicate index access, disabling indexability indexed columns isolation levels LIKE predicate list prefetch, disabling NOT keyword, avoiding ordering columns ordering rows partition key ranges PLAN_TABLE columns 2nd predicate sequence 2nd predicate stages 2nd 3rd predicates, reducing 2nd queries, limiting 2nd 3rd query tweaks renaming columns rows, returning rows, selecting 2nd scalar functions SQL Assist statement tables updates, serializing Visual Explain 2nd Gupta Technologies, LLC
|
| < Day Day Up > |