Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: bitmap index with nosort
Hi,
Thanks
CREATE BITMAP INDEX [schema.] index
[ PCTFREE integer ]
Sinardy
-----Original Message-----
Sinardy :
It is expected behavior only. Bit map indexes are not stored in a tree
format and sorting will have no impact.
Best Regards,
-----Original Message-----
Hi all,
This is just for the testing purpose, because one of my oracle book
state the syntax like this :
ON [schema.] table
(column [ ASC | DESC ] [, column [ ASC | DESC ] ] ...)
[ TABLESPACE tablespace]
[ INITRANS integer ]
[ MAXTRANS integer ]
[ storage-clause ]
[ LOGGING| NOLOGGING ]
[ NOSORT ] <--
Gopalakrishnan
Sent: 13 March 2002 16:03
To: Multiple recipients of list ORACLE-L
Have a look at bit map concepts in Oracle Documentation.
K Gopalakrishnan
Sent: Tuesday, March 12, 2002 11:38 PM
To: Multiple recipients of list ORACLE-L
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:
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
![]() |
![]() |