Hi, one question please What means to Pre-fetch an index. This means to force a full index scan to load in memory? Thank you in advance -- Oracle Certified Profesional 9i 10g Orace Certified Professional Developer 6i 8 years of experience in Oracle 7,8i,9i,10g and developer 6i -- //www.freelists.org/webpage/oracle-l