Dedications
by Carrie King Taylor, Steve Bradley, Naresh Adurty, Brian Taylor
The Official New Features Guide to Sybase ASE 15
- Dedications
- Contents
- Foreword
- Acknowledgments
- About the Authors
- About the Contributing Authors
- Introduction
- Part I New Features Overview
- Chapter 1 Exploring the Sybase Galaxy
- Part I — New Features Overview
- System Maintenance Improvements
- Partition Management — Semantic Partitions
- Scrollable Cursors
- Overview of Changes to Query Processing
- Detection and Resolution of Performance Issues in Queries
- Computed Columns
- Functional Indexes
- Capturing Query Processing Metrics
- Plan Viewer
- Sybase Software Asset Management (SySAM) 2.0
- Installation of ASE 15
- Part II — Pre-15 Improvements
- The Appendices
- 3, 2, 1, Contact!
- Part I — New Features Overview
- Chapter 2 System Maintenance Improvements
- Recent Pre-ASE 15 Improvements
- ASE 15 Improvements
- Row Locked System Catalogs
- Update Statistics
- Automatic Update Statistics
- Datachange
- Datachange, Semantic Partitions, and Maintenance Schedules
- Local Indexes
- sp_helpindex
- Partition-level Utilities
- Very Large Storage System
- Unicode Text Support
- New Datatypes
- New Functions
- Deprecated Functions
- New Configuration Parameters
- Eliminated Configuration Parameters
- New Global Variables
- Summary
- Chapter 3 Semantic Partitions and Very Large Database (VLDB) Support
- Introduction
- Semantic Partitions
- Partitioning Strategies
- Inserting, Updating, and Deleting Data in Partitions
- Built-in Functions
- Data Partition Implementation and Upgrade Strategies
- Index Partitioning
- Local Index
- Clustered Prefixed Index on Range Partitioned Table
- Clustered Non-Prefixed Index on Range Partitioned Table
- Clustered Prefixed Index on List Partitioned Table
- Clustered Non-Prefixed Index on List Partitioned Table
- Clustered Prefixed Index on Round-robin Partitioned Table
- Clustered Non-Prefixed Index on Round-robin Partitioned Table
- Clustered Non-Prefixed Index on Hash Partitioned Table
- Clustered Prefixed Index on Hash Partitioned Table
- Global Index
- Local Index
- Query Processor and Partition Support
- ASE 15 Optimizer
- Partition Maintenance
- Partition Information
- Influence of Partitioning on DBA Activities
- Influence of Partitioning on Long-time Archival
- Summary
- Chapter 4 Scrollable Cursors
- Chapter 5 Overview of Changes to the Query Processing Engine
- Chapter 6 Detection and Resolution of Query Performance Issues
- Introduction
- An Approach to Poor Query Performance Diagnosis
- Common Query Performance Factors
- Eliminating Causes for Sub-Optimal Plan Selection
- Find Missing or Invalid Statistics
- Consider Range Cell Density on Non-Unique Indexes
- Identify Index Needs
- Identify Poor Index Strategy
- Fragmentation of Data
- Resolve Partition Imbalance
- Reset Server- or Session-level Options
- Overengineered Forceplan
- Invalid Use of Index Force
- Inefficient Query Plan Forced by Abstract Plan
- Eliminating Causes for Sub-Optimal Plan Selection
- Query Processor “set options” — The Basics
- Query Processor “set options” — Explored
- Application of Optimization Tools
- Detection, Resolution, and Prevention of Partition-related Performance Issues
- Summary
- Chapter 7 Computed Columns
- Chapter 8 Functional Indexes
- Chapter 9 Capturing Query Processing Metrics
- Alternatives to Query Processing Metrics
- Introduction to Query Processing Metrics
- How to Enable QP Metrics Capture
- Captured Information Explored
- Accessing Captured Plans
- How Is the QP Metrics Information Useful?
- Identification of Performance Regression
- Comparing Metrics for a Specific Query between Running Groups
- Comparing Metrics for All Queries between Running Groups
- Syntax Style Matters; Spacing Does Not
- Clearing and Saving the Metrics
- Relationship between Stats I/O and QP Metrics I/O Counts
- Information for Resource Governor
- Space Utilization Considerations
- Limitations
- Summary
- Chapter 10 Graphical Plan Viewer
- Chapter 11 Sybase Software Asset Management (SySAM) 2.0
- Chapter 12 Installation of ASE Servers
- Chapter 1 Exploring the Sybase Galaxy
- Part II Pre-15 Improvements
- Chapter 13 Multiple Temporary Databases
- Chapter 14 The MDA Tables
- Chapter 15 Java, XML, and Web Services in ASE
- Introduction
- Java in the Database
- XML in the Database
- XML Stored in the Database
- Option 1: Store the XML Document into a Text Datatype
- Option 2: Store the XML Document into an Image Datatype Using xmlparse
- Option 3: Store the XML Document into an Image Datatype Using Compression
- Option 4: Store the XML Document Outside the Database
- HTML Stored in the Database
- Recommendations and Considerations
- Performance and Sizing
- SQL Result Sets Converted to Return an XML Document
- XML Stored in the Database
- Web Services
- Web Services Producer
- Web Services Consumer
- Recommendations and Considerations
- Appendix A Sybase ASE 15 Certification Sample Questions and Answers
- Appendix B Use Cases
- Business Case 1
- Option 1: One VLDB with large tables self contained
- Option 2: Primary database and an archive database for the largest tables
- Option 3: Several small databases, each holding a portion (none overlapping) of the data from the very large tables
- Option 4: One VLDB with a large table, partitioned semantically
- Business Case 2
- Business Case 3
- Business Case 1
- Index
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.