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 |
|
arunsqladmin
Yak Posting Veteran
74 Posts |
 Posted - 2007-12-24 : 00:31:10
|
| what is re-organization.how do i implement it ,what are the steps which i need to take care if it is a production server |
|
|
pootle_flump
1064 Posts |
Posted - 2007-12-24 : 04:56:30
|
| Do you mean index reorganisation? Try reading BoL under Alter Index and google "sql server index defragmentation rebuild reorganise" |
 |
|
|
arunsqladmin
Yak Posting Veteran
74 Posts |
Posted - 2007-12-24 : 05:31:43
|
| are there different types of re-organization ,the one which i am talking about is to improve the performance and re arrange all the clustered data... |
|
|
|
pootle_flump
1064 Posts |
Posted - 2007-12-24 : 06:08:23
|
| That is index reorganisation. If you know SQL 2000 it is equivalent to DBCC indexdefrag. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-24 : 16:12:17
|
| And compare it with reindex, you need rebuild index when table is highly fragmented. |
|
|
|
|
|
|
re-organization?