New Features in ALLBASE/SQL Release G.0 (continued)

Feature (Category)

Description

Documented in . . .

 

 

 

I/O performance

Optimizes I/O for initial load,

ALLBASE/SQL Reference Manual , \SQL

improvement

index build, serial scans, in ternal

Statements."

(Performance)

data restructuring, ￿le activit y,

 

 

pseudo mapped ￿les and

 

 

temporary ￿les. See the follo wing

 

 

features for new and c hanged

 

 

syntax.

 

 

 

 

TRUNCATE

Deletes all rows in a speci￿ed table

ALLBASE/SQL Reference Manual ,

TABLE statement

leaving its structure in tact.

TRUNCATE TABLE in \SQL Statemen ts."

(Performance)

Indexes, views, default v alues,

 

 

constraints, rules de￿ned on the

 

 

table, and all authorizations are

 

 

retained. TRUNCATE TABLE is

 

 

faster than the DELETE

 

 

statement and generates few er

 

 

logs. New statement:

 

 

TRUNCATE TABLE.

 

 

 

 

New scans

Reads tables with a new parallel

(Performance)

sequential scan. The tables are

 

partitioned and ￿les are read in a

 

round robin fashion to allow OS

 

prefetch to be more e￿ective.

 

Allows the I/O for a serial scan to

 

spread across m ultiple disc drives.

 

 

ALLBASE/SQL Performance and Monitoring Guidelines , \Using Parallel Serial Scans" in \Guidelines on Query Design."

Load performance

Improves performance with new

ALLBASE/SQL Reference Manual , SET

improvement

SET and SET SESSION

SESSION in \SQL Statemen ts."

(Performance)

attributes, a new binary searc h

 

 

algorithm, and deferred allocation

 

 

of HASH pages. New attributes

 

 

for SET SESSION statemen t:

 

 

FILL, PARALLEL FILL.

 

 

 

 

ISQL enhanced to

Uses new parameters of the ISQL

improve the

SET command to set load bu￿er

performance of

size and message reporting.

LOADs

Improves load performance.

(Performance)

Choose a procedure, command ￿le,

 

or new ISQL command to set

 

constraints deferred, lock table

 

exclusively, and set row level DML

 

atomicity. Changed syntax: SET

 

(see the follo wing feature).

 

 

ISQL Reference Manual for ALLBASE/SQL and IMAGE/SQL, SET in \ISQL

Commands."

xi