SQL/MP Query Guide

About This Manual
HP NonStop SQL/MP Query Guide—524488-003
xiv
Related Manuals
Related Manuals
This manual is part of the NonStop SQL/MP library of manuals, as shown in Figure i on
page -xv.
In addition to this manual, the library includes these manuals:
•
Introduction to NonStop SQL/MP provides an overview of the NonStop SQL/MP
relational database management system.
•
SQL Quick Start describes how to use basic features of the NonStop SQL/MP
conversational interface (SQLCI), how to execute simple queries, and how to use
the SQLCI report writer to produce a simple formatted report.
•
SQL/MP Reference Manual describes the language elements and statement and
command syntax for all NonStop SQL/MP statements and SQLCI commands.
•
SQL/MP Report Writer Guide describes use of the NonStop SQL/MP report writer
commands and SQLCI options that relate to reports.
•
SQL/MP Programming Manual (available for C and COBOL) and the SQL
Programming Manual (available for Pascal and TAL) describe the programmatic
interface for the particular host language.
•
SQL/MP Installation and Management Guide describes how to perform the tasks of
planning, installing, creating, and managing a NonStop SQL/MP database.
•
SQL/MP Version Management Guide provides guidelines for managing NonStop
SQL/MP installations using the NonStop SQL/MP version management system.
•
SQL/MP Messages Manual describes NonStop SQL/MP messages for the
NonStop SQL/MP conversational interface, the application programming interface,
and NonStop SQL/MP utilities, as well as file-system and FastSort messages
returned by NonStop SQL/MP.
•
SQL/MP Glossary describes the SQL database terminology used in the NonStop
SQL/MP documentation library.
Section 4, Improving Query
Performance With
Environmental Options
Discusses several environmental factors that can influence
query performance
Section 5, Selectivity and
Cost Estimates
Discusses how the optimizer estimates selectivity, assigning
cost to a query, evaluating cost estimates, how the
optimizer chooses an execution plan, and forcing execution
plans.
Section 6, Analyzing Query
Performance
Discusses how to analyze query performance by using
DISPLAY STATISTICS, the Measure product, and the
EXPLAIN utility.
Table i. Summary of Contents (page2of2)