Large amount of data processing in database

1. Indexing, clustered and nonclustered indexes are established.
Clustered indexes are physically contiguous, nonclustered indexes are physically discontinuous, and index tables are used to find data.
Only one clustered index can be built per table

2. This article talks about a more comprehensive
Http://blog.csdn.net/softeer/archive/2005/11/08/525353.aspx

3. When the amount of data in a table is large, it often times out if you add a field by right-clicking the table name--modifying it.
You can execute the SQL statement directly: Alter table1 add fieldnew int Default ((0))