i*a
2 楼
Check index fragmentation.
【在 U****D 的大作中提到】
: Is there a standard? Thanks.
【在 U****D 的大作中提到】
: Is there a standard? Thanks.
U*D
3 楼
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?
【在 i****a 的大作中提到】
: Check index fragmentation.
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?
【在 i****a 的大作中提到】
: Check index fragmentation.
B*g
4 楼
Are you a administrator?
index
【在 U****D 的大作中提到】
: 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?
index
【在 U****D 的大作中提到】
: 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?
U*D
5 楼
Want to be one.
【在 B*****g 的大作中提到】
: Are you a administrator?
:
: index
【在 B*****g 的大作中提到】
: Are you a administrator?
:
: index
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 的大作中提到】
: 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 的大作中提到】
: 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?
U*D
7 楼
2008 SQL server.
Unfortunately, no partition at all.
【在 i****a 的大作中提到】
: 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
Unfortunately, no partition at all.
【在 i****a 的大作中提到】
: 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
i*a
8 楼
then only rebuild the index that's fragmented
【在 U****D 的大作中提到】
: 2008 SQL server.
: Unfortunately, no partition at all.
【在 U****D 的大作中提到】
: 2008 SQL server.
: Unfortunately, no partition at all.
U*D
9 楼
OK. Thanks.
【在 i****a 的大作中提到】
: then only rebuild the index that's fragmented
【在 i****a 的大作中提到】
: then only rebuild the index that's fragmented
g*l
10 楼
是的，可以写个SP CHECK FRAMENTATION所有的INDEX，然后REBUILD FRAMENTATION到一
定程度，比如40%+的。注意REBUILD要在系统IDLE的时候半夜鸡叫的时候，不要有其它
JOB或者BACKUP RUN，看你的时间那么长，你的数据可能需要ARCHIVE了
定程度，比如40%+的。注意REBUILD要在系统IDLE的时候半夜鸡叫的时候，不要有其它
JOB或者BACKUP RUN，看你的时间那么长，你的数据可能需要ARCHIVE了
a9
11 楼
index碎片影响到底有多大？感觉实际上没什么太大影响吧？
【在 g***l 的大作中提到】
: 是的，可以写个SP CHECK FRAMENTATION所有的INDEX，然后REBUILD FRAMENTATION到一
: 定程度，比如40%+的。注意REBUILD要在系统IDLE的时候半夜鸡叫的时候，不要有其它
: JOB或者BACKUP RUN，看你的时间那么长，你的数据可能需要ARCHIVE了
【在 g***l 的大作中提到】
: 是的，可以写个SP CHECK FRAMENTATION所有的INDEX，然后REBUILD FRAMENTATION到一
: 定程度，比如40%+的。注意REBUILD要在系统IDLE的时候半夜鸡叫的时候，不要有其它
: JOB或者BACKUP RUN，看你的时间那么长，你的数据可能需要ARCHIVE了
相关阅读
公司里的contract和temp job有什么区别？想建网站，求主意Oracle Deadlock看看这database server 要升极吗问个超级无敌白菜问题teradata和oracle比较file based databaseImport data in R菜鸟急问一个关于用frontpage往数据库里写数据的问题how to get command history in sqlpus within Screen shell?找工作sql dev/dba, data analyst, SAS请帮我看看，什么地方错了？请教专家：这种宽泛的问题怎么准备阿？software testing/QA 和database相比，哪个方向更好找工作？如何复制数据最快?Access数据库能生成可执行文件么?SQLCODE = -1Question: ORACLE sql result with single quotationSQL Server DBA opening in Rockville, MD.请教：web hosting用windows+mysql