Index Skip scan
Hi My oracle version is 11.2.0.2.0. The below query is not using index though one composite index is present. explain plan <font color="#000080"><b>for</b></font> SELECT code, type FROM MAT WHERE MAT.id = :1 ORDER BY code; PLAN_TABLE_OUTPUT ------------------------------------------------------------------------------------------------------------------------ Plan hash value: 1862655975 ------------------------------------------------------------------------------------------ | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ------------------------------------------------------------------------------------------ | 0 | SELECT STATEMENT | | 2546 | 33098 | |
0