Presentation Information

Presentation Title:   Latest SQL features the reduce maintenance downtime
Primary Speaker:   Jeffrey McMahon
Presentation
Abstract:
  
The presentation describes the most recent features that help
reduce maintenance downtime. Such topics include:

-NOVALIDATE options for constraints (check and unique).
-RENAME INDEX (system generated indexes)
-RENAME CONSTRAINT
-TRUNCATE TABLE keep statistics
-In-place alter for varchar extension
-In-place alter to not rebuild indexes for case of varchar IPA when
varchar size is increased.
-In-place alter for all integer -> serial types
-MODIFY COLUMN for primary key and then modify the foreign key
columns in a separate operation
Co-Speakers
or Panelists:
  
None