Jump to content United States-English
HP.com Home Products and Services Support and Drivers Solutions How to Buy
» Contact HP
More options
HP.com home
ALLBASE/SQL Performance and Monitoring Guidelines: HP 3000 MPE/iX Computer Systems > Chapter 3 Guidelines on Query Design

Modifying the Access Optimization Plan with SETOPT

» 

Technical documentation

Complete book in PDF
» Feedback
Content starts here

 » Table of Contents

 » Index

By default, the ALLBASE/SQL optimizer chooses the access plan for queries. You can specify the access plan with the SETOPT statement. For example, you can specify the use of either serial, index, or hash access for a particular statement. See the "SETOPT" section in the ALLBASE/SQL Reference Manual for more information.

Printable version
Privacy statement Using this site means you accept its terms Feedback to webmaster
© Hewlett-Packard Development Company, L.P.