CREATE INDEX statement performs Index fast full scan over another index – Hemant's post
Posted by Kamran Agayev A. on September 22nd, 2011
Yesterday, Hemant K. Chitale, who’s co-author of my book “Oracle Backup & Recovery: Expert secrets for using RMAN and Data Pump” posted an interesting article where shows how CREATE INDEX statement performs INDEX FAST FULL SCAN over another index to speed up the process. You can read the article from the following link:
http://hemantoracledba.blogspot.com/2011/09/index-that-is-subset-of-pre-existing.html