--------------------------------------------------------------------------------
---------------------------------------------------------------------------
| id | operation | name | rows | bytes | cost |
---------------------------------------------------------------------------
| 0 | select statement | | | | |
| 1 | table access by index rowid| dept | | | |
|* 2 | index range scan | dept_id1 | | | |
---------------------------------------------------------------------------
predicate information (identified by operation id):
---------------------------------------------------
2 - access("dept"."dname">'developer' and "dept"."dname"<'developer')
note: rule based optimization
15 rows selected
