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 |
|
jbates99
Constraint Violating Yak Guru
396 Posts |
 Posted - 2011-03-06 : 14:24:48
|
| Hi everyone,This is 2005 SP3Reorganixe Index has an option for compacting large objects. As I understand it, this compacts columns that are Text/ntext or image.But compacted data must be uncompacted by SQL Server when read, correct?Any recommendations on whether I should use the 'Compact' option when I reorganize indexes? I don't have any image data but lots of text data.Thanks, John |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-03-06 : 17:48:57
|
| Not compact as in compress, compact as in put neatly together and discard empty space--Gail ShawSQL Server MVP |
 |
|
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 2011-03-06 : 18:09:59
|
| Oh, thanks GilaMonster.In that case, seems it would be good to use that option.John |
|
|
|
|
|
|
The Compact Large Objects option in Reorg Index