性能相关
-
编辑 删除
10g新特性之multi-block reads自动调优
总所周知，在oracle中进行full table scan、index fast full scan时，为了提高读取的性能，oracle将采用多块IO，而不再是单块IO，参数db_file_multiblock_read_count控制着Oracle一次多块IO的数据库块数(严格来说应...
-
编辑 删除
什么时候应该重建索引？(转载)
When Should You Rebuild an Index?by Jonathan LewisIn an earlier article about B-tree indexes, I ended with the comment, “Resist the argument that you need to rebuild Indexes regularly because ‘th...
