RE: bitmap index with nosort

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Wed, 13 Mar 2002 00:03:19 -0800
Message-ID: <F001.00426884.20020313000319@fatcity.com>

Sinardy :

It is expected behavior only. Bit map indexes are not stored in a tree format and sorting will have no impact.
Have a look at bit map concepts in Oracle Documentation.

Best Regards,
K Gopalakrishnan
Bangalore, INDIA

-----Original Message-----
Sent: Tuesday, March 12, 2002 11:38 PM
To: Multiple recipients of list ORACLE-L

Hi all,

I try create bitmap index with nosort

like:

SQL> select kill from emp;

      KILL

---

         1
         2
         3
         4
         5
         6
         7
         8
         9

9 rows selected.

SQL> create bitmap index bmap1 on emp(kill asc) nosort; create bitmap index bmap1 on emp(kill asc) nosort

                                           *

ERROR at line 1:
ORA-25110: NOSORT may not be used with a bitmap index

Can I use nosort when creating bitmap index

Thanks

Sinardy

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinard Xing
  INET: sinardyxing_at_bcs-ach.com.sg

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: K Gopalakrishnan
  INET: kaygopal_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Wed Mar 13 2002 - 02:03:19 CST