Neoview Control Query Default (CQD) Reference Guide (R2.5)

About This Document

This guide describes Neoview Control Query Defaults (CQDs) that are used to override

system-level default settings.

Supported Release Version Updates (RVUs)

This guide supports N02.05 and all subsequent N-series RVUs until otherwise indicated in a

replacement publication. N02.05 is the Neoview RVU provided with Release 2.5.

Intended Audience

This guide is intended for database administrators and application programmers who want to

use CQDs to override system-default settings when querying a database on an HP Neoview data

warehousing platform.

Document Organization

This document is organized by chapters:

Content SummaryChapter or Appendix

Provides overview information and describes how to set CQDsChapter 1 (page 11)

Describes CQDs that are used for managing adaptive segmentationChapter 2 (page 13)

Describes CQDs that are used for managing SkewChapter 3 (page 15)

Describes CQDs that are used for automated STATS generationChapter 4 (page 17)

Describes CQDs that are used by the OptimizerChapter 5 (page 21)

Describes CQDs that are used for file size and placement (POS)Chapter 6 (page 29)

Describes CQDs that are used for histogramsChapter 7 (page 31)

Describes CQDs that are used by the sequence generatorChapter 8 (page 37)

Describes CQDs that are used for managing catalogs and schemasChapter 9 (page 41)

Describes CQDs that are used for managing materialized viewsChapter 10 (page 43)

Describes CQDs that are used for managing isolation levelsChapter 11 (page 45)

Describes CQDs that are used by the ExecutorChapter 12 (page 47)

Describes CQDs that are used for transaction control and lockingChapter 13 (page 49)

Describes CQDs that are use to control the compiler cacheChapter 14 (page 57)

Describes miscellaneous CQDsChapter 15 (page 59)

Notation Conventions

General Syntax Notation

This list summarizes the notation conventions for syntax presentation in this manual.

UPPERCASE LETTERS

Uppercase letters indicate keywords and reserved words. Type these items exactly as shown.

Items not enclosed in brackets are required. For example:

SELECT

Supported Release Version Updates (RVUs) 7