基本数据库存取 Basic data access

学习了Tom巡回演讲中的一节, 使用索引:

下面两种引用简单程序逻辑的比喻,非常贴切,这也是鄙人面试时,经常问到的一个题目.

a) say out loud - full scans are not evil
b) say out loud - indexes are not all goodness
c) goto (a) until you actually believe what you are saying out loud.

参考: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:743251200346166176


Mythology – why isn’t it using my index

–Loop

•Say indexes are not all goodness

•Say full scans are not evil

•Exit when (you really believe it)

–End loop

参考: Indexing.ppt , 下载: http://asktom.oracle.com/pls/asktom/f?p=100:8:1413269270550111::NO