NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
B-5
Considerations—BLOCKSIZE
block size greater than 4096 for a CREATE TABLE or CREATE INDEX statement,
SQL issues an error.
Considerations—BLOCKSIZE
•
Recommendations for block size
For sequential processing, use the largest block size.
For key-sequenced tables, avoid small block sizes (less than 4096 bytes) if the size
of the table causes the number of index levels to increase over the number required
for 4096-byte blocks. Additional index levels can reduce online performance.
If your application uses a table or index to process data solely with random access,
choose one of the smaller block sizes for that table or index. Note, however, that
small block sizes require more disk space for the same number of rows than large
block sizes.
BREAK FOOTING Command
BREAK FOOTING is an SQLCI report writer command that specifies the text at the
end of a group of break column values. You can use BREAK FOOTING only from the
select-in-progress prompt, not from the SQLCI prompt.
break-column
identifies a break column (a column named in a BREAK ON command). It can be a
column name, an alias, a detail alias, or COL number (which specifies the position
of the column in the select list).
print-item
specifies the contents and format of items to print when the value in the break
column changes. print-item is the same as described under the DETAIL
command except that it cannot include the HEADING, NOHEAD, or NAME
clauses. (See DETAIL Command
on page D-43 or Print Item on page P-27 for more
information.)
If print-item is a column identifier, the column value will be the one from the
last select row in the group.
CENTER
centers each line of the break footing between the left and right margins. If you omit
CENTER, the break footing is positioned at the left margin.
BREAK FOOTING break-column (print-list) [CENTER];
print-list is:
print-item [, print-item] ...