Using Virtual Indices In Oracle 10g And 11g

• Using Virtual Indices In Oracle 10g And 11g

  Play:

  Click here to play

  Author:

  Michael L. Simpson - click to view profile

  Description:

  Proper indices are an important means of improving Oracle performance by changing the access paths used to go after data. However, building different indices to test different access paths can be time consuming. Join Mike Simpson as he shows you how to create virtual (segment-free) indices; how to use a hidden feature to direct Oracle to use these virtual indices; and how virtual indices influence the optimizer path on "Virtual Indices in Oracle 10g".