cell smart index scan等待事件
原创maclean_007 ©著作权
©著作权归作者所有:来自51CTO博客作者maclean_007的原创作品,请联系作者获取转载授权,否则将追究法律责任
This is an Exadata wait event that occurs when fast full index scans are offloaded to the storage cells. This event is related to cell smart table scan except that the object is an index.
This event does not show up very frequently in Exadata probably because it is very good at performing full table scans and index reads may actually be less efficient. Also, only full fast scans (not range or full scans) of indexes are eligible for smart scans, which reduces the likelihood of seeing this event.
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
index seek与index scan
低效 Index Scan(索引扫描):就全扫描索引(包括根页,中间页和叶级页): 高效 Index Seek(索引查找):通过索引向前和向后搜索 :
职场 休闲 index seek与index sca