SQL/MP Installation and Management Guide

Contents

HP NonStop SQL/MP Installation and Management Guide—523353-004

14. Enhancing Performance (continued)

Knowing When to Update Statistics 14-7

Analyzing the Possible Impact of Running UPDATE STATISTICS 14-8

Testing UPDATE STATISTICS 14-9

Running UPDATE STATISTICS 14-11

Using a Test Database for Emulation 14-12

Obtaining Statistics 14-12

Altering Statistics 14-14

Deleting a Test Database 14-15

Optimizing Index Use 14-16

Maximizing Parallel Index Maintenance 14-17

Managing Cache Memory Size 14-17

Maximizing Disk Process Prefetch Capabilities 14-18

Managing File System Double Buffering 14-18

Using an SQL DEFINE to Manage PFS Utilization 14-19

Changing the PFS Size Limit 14-20

Additional DEFINEs for Managing Double Buffering 14-21

Using Generic Locks 14-21

Checking Data Integrity 14-23

Creating Logical Views of Data 14-24

Specifying Block Sizes for Files 14-24

Adding and Dropping Partitions 14-25

Avoiding Automatic Recompilations 14-25

Matching Block Split Operation to Table Usage 14-25

Supporting Sort Operations 14-26

Specifying Scratch Volumes 14-26

Enhancing Query Performance 14-27

Supporting Parallel Query Execution 14-27

Planning for Temporary File Requirements 14-28

A. Licensed SQLCI2 Process

Licensing SQLCI2 A-1

Running SQLCI2 as SUPER.SUPER A-1

Running SQLCI2 as another user A-2

Revoking an SQLCI2 License A-3

B. Removing SQL/MP From a Node

Using the PUP FORMAT Command to Remove SQL Objects B-1

Using the CLEANUP Utility to Remove SQL Objects B-1