i*a
6 楼
SQL server? 2005 or later?
you can have horizontally partitioned tables, and only rebuild index on
the partitions that have fragments. but it's not a simple change if the
database is not already setup this way
index
【在 U****D 的大作中提到】![](/moin_static193/solenoid/img/up.png)
: Thanks.
: We have a 800G database. The administrator set the reorganize/Rebuild index
: once a week. It takes more than 2 hours to reorganize index and over 8
: hours to rebuild index. Is there a way to shorten the time?
you can have horizontally partitioned tables, and only rebuild index on
the partitions that have fragments. but it's not a simple change if the
database is not already setup this way
index
【在 U****D 的大作中提到】
![](/moin_static193/solenoid/img/up.png)
: Thanks.
: We have a 800G database. The administrator set the reorganize/Rebuild index
: once a week. It takes more than 2 hours to reorganize index and over 8
: hours to rebuild index. Is there a way to shorten the time?
g*l
10 楼
是的,可以写个SP CHECK FRAMENTATION所有的INDEX,然后REBUILD FRAMENTATION到一
定程度,比如40%+的。注意REBUILD要在系统IDLE的时候半夜鸡叫的时候,不要有其它
JOB或者BACKUP RUN,看你的时间那么长,你的数据可能需要ARCHIVE了
定程度,比如40%+的。注意REBUILD要在系统IDLE的时候半夜鸡叫的时候,不要有其它
JOB或者BACKUP RUN,看你的时间那么长,你的数据可能需要ARCHIVE了
相关阅读
请求帮助,关于存储计算Any other good oracle discussion/forum?Access中如何update 100个fields让他们都乘以25%?问一个excel的弱问题怎么写这个Query,谢谢which one is faster? truncate or delete?Oracle OCP 求助~~~Help: "Operation Must Be Updatable Query"大侠们,问一个查询怎么写,急!为啥不能delete Excel记录???any tool to load xml file into oracle?求教php设置问题How to add a blank column in a Query?great site to share; free问个RMAN问题这里有没有人上过Access 用户权限设置的疑问A SQL problemMS SQL = or like?伤心,excel