Re: How I Pre-fetch an index?

I found this on metalink:
select /*+ index(bdd_prov bdd_prov_idx) */ int_nom_inst /* all columns that belong to the index */ from bdd_prov
where int_nom_inst = int_nom_inst ;

Verify with explain plan that this will do full index scan.

Do not forget alter index storage(buffer_pool keep).

Yechiel Adar
Mehish Computer Services
----- Original Message -----
From: "Juan Carlos Reyes Pacheco" <juancarlosreyesp_at_gmail.com> To: "oracle-l" <Oracle-L_at_freelists.org>
Sent: Thursday, February 17, 2005 12:32 AM Subject: How I Pre-fetch an index?

> Hi, one question please
> What means to Pre-fetch an index.
> This means to force a full index scan to load in memory?

--
http://www.freelists.org/webpage/oracle-l