Index Range Scan example with explain plan output ?
Can someone give me a example of a
'index range scan'
;
When I write the query for a range scan it seems to be going for a unique scan
SQL> select employee_name from employeees
where dept_id = 10;
but the example given in the oracle-documentation
'13-18 Oracle Database Performance Tuning Guide'
for ORacle 10g shows that it works and gives a 'INDEX RANGE SCAN'.
How can i do this ? OR whats wrong in my query (that it doesnt give the desired plan)
0