TY - BOOK AU - Hasler,Tony TI - Expert Oracle SQL: : optimization, deployment, and statistics T2 - Expert's voice in Oracle SN - 9781430259770 U1 - 005.7565 PY - 2014///] CY - [Berkeley, California] PB - [Apress] KW - Oracle (Computer file) KW - SQL (Computer program language) KW - Database management N1 - Includes index; Part 1. Basic concepts; SQL features; The cost-base optimizer; Basic execution plan concepts; The runtime engine; Introduction to tuning; Objects statistics and deployment; Part 2. Advanced concepts; Advanced SQL concepts; Advanced execution plan concepts; Object statistics; Part 3. The cost-based optimizer; Access methods; Joins; Final state optimization; Optimizer transformations; Part 4. Optimization; Why do things go wrong?; Physical database design; Rewriting queries; Optimizing sorts; Using hints; Advanced tuning techniques; Part 5. Managing statistics with TSTATS; Managing statistics with TSTATS ER -