Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
enum5
Starting Member
2 Posts |
Posted - 2006-12-05 : 04:25:50
|
I am trying to rename a table in a database. The table name is Message_Log and has about 300 Million records. This table has one clustered index and 5 non-clustered indexes. I want to rename it to Message_Log_200611. Then I create a new table with name Message_Log. Will this affect the indexes in old Message_Log table? Will the process takes long time to finish? |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-05 : 04:30:11
|
* If using SQL 2000Have to tables one with each user's last 100 messags or so, and one table for history purposes.Create a view to select from both tables.* If using SQL 2005Use partitioned tables with 1 month of data for "top" partition, and the all other data in the other partition.Peter LarssonHelsingborg, Sweden |
|
|
enum5
Starting Member
2 Posts |
Posted - 2006-12-05 : 05:29:15
|
Ok. May I know will the indexes in old Message_Log table be corrupted if i change the table name to Message_Log_200611? Will the process of renaming the table with 300 million records take long time to finish in 3 Giga hertzs processing speed server with 2 Giga byte RAM memory? |
|
|
|
|
|