zjreset的专栏

转载 如何看懂ORACLE执行计划

<br />一、什么是执行计划<br />An explain plan is a representation of the access path that is taken when a query is executed within Oracle.<br /><br />二、如何访问数据<br />At the physical level Oracle reads blocks of data. The smallest amount of data read is a single Oracl