Re: How I Pre-fetch an index?
- From: "Yechiel Adar" <adar76@xxxxxxxxxxxx>
- To: "oracle-l" <Oracle-L@xxxxxxxxxxxxx>
- Date: Thu, 17 Feb 2005 22:08:07 +0200
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@xxxxxxxxx>
To: "oracle-l" <Oracle-L@xxxxxxxxxxxxx>
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?
--
//www.freelists.org/webpage/oracle-l
Other related posts:
