WarpSQL Server, an open source OLAP focused distribution of the world's most popular open source database bundled with OLAP performance related plugins such as the WARP storage engine..
The following should be supported without rebuilding the entire table but still require a table lock:
Adding keys
Dropping keys
Adding columns
Dropping columns
Changing default values
The following should require rebuilding a table:
ADD PRIMARY KEY
ADD UNIQUE KEY
The following should be supported without rebuilding the entire table but still require a table lock: Adding keys Dropping keys Adding columns Dropping columns Changing default values
The following should require rebuilding a table: ADD PRIMARY KEY ADD UNIQUE KEY