First page Back Continue Last page Graphics

Access Paths Workshop: Index Access Paths 1


Notes:

Workshop – Index Access Paths Part 1
Refer to the supplied script workshop_index_path.sql.
Create the object required to eliminate table access for the following query? It should use an index fast full or index range scan.
select object_name from big where object_type = 'A';
Can you write a query that will do an index skip scan using the index you just created?