What the difference between rebuild index and re-organize index?
来源:互联网 发布:淘宝排名靠前技巧 编辑:程序博客网 时间:2024/05/18 17:57
avg_fragmentation_in_percent value
Corrective statement
> 5% and < = 30%
ALTER INDEX REORGANIZE
> 30%
ALTER INDEX REBUILD WITH (ONLINE = ON)*
* Rebuilding an index can be executed online or offline. Reorganizing an index is always executed online. To achieve availability similar to the reorganize option, you should rebuild indexes online.
0 0
- What the difference between rebuild index and re-organize index?
- Difference between Full Index Scans and Fast Full Index Scans
- What is the difference between test, [ and [[ ?
- Table and Index rebuild
- What's different between INDEX and KEY in database
- what is the difference between the setTimeout and setInterval
- What is the difference between DHTML and the DOM?
- What is the difference between the mouseover and mouseenter events?
- What is the difference between AWT and SWT?
- What's the difference between an event and a delegate?
- what's the difference between OnDraw and OnPaint
- What is the difference between User Control and Custom Control?
- What is the difference between an EXE and a DLL?
- What is the difference between XML and C or C ?
- What is the difference between SMOD and CMOD?
- what is the difference between little-endian and big-endian.
- What is the difference between procedural and nonprocedural language?
- What are the difference between DDL, DML and DCL commands?
- 15-1 工资数据的输入(从一个文件中读出读入另一个文件中)
- 企业少人化管理的优势
- SAP BW 术语表
- traceroute小结
- 经纬财富:南平现货白银开户流程
- What the difference between rebuild index and re-organize index?
- Centos 6.3 源码编译安装 apache
- 内存分配方式
- map中make_pair的使用实例
- SQLiteOpenHelper类的onCreate方法什么时候被执行
- Swift学习——A Swift Tour 数据类型
- 60款开源云应用【Part 2】(60 Open Source Apps You Can Use in the Cloud)
- windows 程序设计一
- 软件工程系学生在全国程序设计大赛中获得优异成绩