3.While observing the index statistics, you find that an index is highly fragmented, thereby resulti
来源:互联网 发布:王权富贵东方月初乐乎 编辑:程序博客网 时间:2024/06/06 14:24
3.While observing the index statistics, you find that an index is highly fragmented, thereby resulting in
poor database performance. Which option would you use to reduce fragmentation without affecting the
users who are currently using the index?
A.Validate the index structure using the ANALYZE...INDEX command.
B.Rebuild the index using the ALTER INDEX..REBUILD ONLINE command.
C.Change the block space utilization parameters using the ALTER INDEX command.
D.Deallocate the unused space in the index using the ALTER INDEX..DEALLOCATE UNUSED command.
答案:B
解析:由于频繁的dml,索引就会产生碎片,它的效率会越来越慢,因此就需要重建,
可以使用online关键字在线重建索引,因为重建索引的时候会加锁,假如该关键字后,可以使加锁时间变的很短
poor database performance. Which option would you use to reduce fragmentation without affecting the
users who are currently using the index?
A.Validate the index structure using the ANALYZE...INDEX command.
B.Rebuild the index using the ALTER INDEX..REBUILD ONLINE command.
C.Change the block space utilization parameters using the ALTER INDEX command.
D.Deallocate the unused space in the index using the ALTER INDEX..DEALLOCATE UNUSED command.
答案:B
解析:由于频繁的dml,索引就会产生碎片,它的效率会越来越慢,因此就需要重建,
可以使用online关键字在线重建索引,因为重建索引的时候会加锁,假如该关键字后,可以使加锁时间变的很短
0 0
- 3.While observing the index statistics, you find that an index is highly fragmented, thereby resulti
- given an array of integers Find the index of values that satisfy A+B = C + D
- 40.You have statistics collected for some selected tables. Your requirement is that the statistics
- Check if index is fragmented (needs reorg or coalesce)
- what is an elasticsearch index?
- Index and Statistics
- Index statistics collected bug
- Java Project提示"Errors occurred during the build. Excepted to find an object at table index”
- Facebook面试题 find the peek or valley index in an array
- Index Monitoring and Index Statistics (The Great Gig In The Sky)
- 137 While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that t
- Given an array of non-negative integers, you are initially positioned at the first index of the arra
- Q9.3 Find the magic index
- 173.Which statement describes the effect on an index, when the indexed column for the rows is update
- 错误 the type "xxxx" is defined in an assembly that is not refernced.You must add a reference to assem
- Given an array of size n, find the majority element. The majority element is the element that appear
- [LinkedIn]find balance (equilibrium) point (index) in an array (unsorted)
- Warning: The VM will try to fix the stack guard now.It's highly recommended that you fix the library
- Drop Table恢复:Oracle中误删表后还原表
- 【转】oracle中exp,imp的使用详解
- 权威大数据应用解决方案
- Android MVP初试
- Failed to load class "org.slf4j.impl.StaticLoggerBinder"异常解决办法
- 3.While observing the index statistics, you find that an index is highly fragmented, thereby resulti
- Linux安装MySQL的两种方法
- Log4j讲解
- linux添加路由
- 字符串格式化显示
- xml格式数据解析
- 社会化分享在QQ互联后台的URL schema应该怎么设置?
- android中实现文字的超链接的应用内跳转
- HDU2502 月之数(解法三)