Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> pct_direct_access for a secondary index on an iot
Hello list, I am unable to get a value in dba_indexes(pct_direct_access) for
a bitmap index I created on an iot. I am using Oracle 9.2.0.1.0
enterprise
edition on windows .
Can someone help me by telling me what I need to do.
I have done the following :
--First create the iot with a mapping table.
sql> create table countries
( country_id char(2) ,
country_name varchar2 (40) ,
currency_name varchar2(25),
constraint country_c_id_pk primary key (country_id ) )
organization index including country_name
pctthreshold 20
tablespace users
overflow tablespace indx
mapping table;
Table created.
SQL> insert into HR.countries values ( 'C', 'A', NULL ) ; 1 row created.
SQL> insert into HR.countries values ( 'D', 'A', NULL ) ; 1 row created.
SQL> insert into HR.countries values ( 'E', 'A', NULL ) ; 1 row created.
SQL> COMMIT ;
Commit complete.
--Now create a bmp index on it.
SQL> create bitmap index myindex on countries (country_name ) ;
Index created.
--This command should analyze the iot and its mapping table.
SQL> analyze table countries compute statistics;
Table analyzed.
--Might as well analyze the bmp index ( this does no harm right ? )
SQL> analyze index myindex compute statistics;
Index analyzed.
SQL> select index_name, pct_direct_access from DBA_indexes where index _name = 'MYINDEX' and owner=user;
INDEX_NAME PCT_DIRECT_ACCESSMYINDEX
------------------------------ -----------------
.....................Thanks
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <bulbultyagi_at_now-india.net.in INET: bulbultyagi_at_now-india.net.in Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Sep 18 2003 - 19:44:40 CDT