Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Fw: pct_direct_access for a secondary index on an iot

Fw: pct_direct_access for a secondary index on an iot

From: <bulbultyagi_at_now-india.net.in>
Date: Tue, 16 Sep 2003 07:14:54 -0800
Message-ID: <F001.005D00D4.20030916071454@fatcity.com>


Resending , didn't seem to have reached the list the first time.

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_ACCESS

------------------------------ -----------------
 MYINDEX
--As you can see I get a null value in the pct_dircect_access column.
 .....................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 Tue Sep 16 2003 - 10:14:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US