读书笔记
-
编辑 删除
查询RMAN恢复进度
set line 190 pages 190 column FILENAME format a70 select sid,serial,filename,status,bytes/total_bytes*100 "Completed",EFFECTIVE_BYTES_PER_SECON
-
编辑 删除
Systematic index design consists of two processes
1. Detect SELECT statements that are too slow due to inadequate indexing Worst input: Variable values leading to the longest elapsed time2. Design indexes that make all SELEC...
-
编辑 删除
Relational Database Index Design and the Optimizers
1. Focus on the maor issues It is vital to focus on the few really major issues,not on the relatively unimportant detail under which many people drown. This iskey—to foc...
