RE: bitmap index with nosort

From: Sinard Xing <sinardyxing_at_bcs-ach.com.sg>
Date: Wed, 13 Mar 2002 00:48:24 -0800
Message-ID: <F001.004269F0.20020313004824@fatcity.com>

Hi,

Thanks
This is just for the testing purpose, because one of my oracle book state the syntax like this :

CREATE BITMAP INDEX [schema.] index
ON [schema.] table
(column [ ASC | DESC ] [, column [ ASC | DESC ] ] ...) [ TABLESPACE tablespace]

[ PCTFREE integer ]
[ INITRANS integer ]
[ MAXTRANS integer ]
[ storage-clause ]
[ LOGGING| NOLOGGING ]
[ NOSORT ] <--

Sinardy

-----Original Message-----
Gopalakrishnan
Sent: 13 March 2002 16:03
To: Multiple recipients of list ORACLE-L

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).

-- 
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).

Received on Wed Mar 13 2002 - 02:48:24 CST