OraFAQ Forum: Server Utilities

Mon, 21 January 2002 12:11

karen
Messages: 19
Registered: January 2002

Junior Member

hi,
why bitmap index can't be unique??????????????????
please explain.
thanx

Tue, 22 January 2002 10:15

Mike
Messages: 417
Registered: September 1998

Senior Member

The Bitmap index is used to index columns which have only few different values. So it doesn't make any sense to use a bitamp index on a column where each value is unique.

For more detail see:
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76994/indexes.htm#97324

Previous Topic:	foreign key
Next Topic:	Re: Oracle Password with Connect internal

Goto Forum:

]

Current Time: Thu Dec 25 14:15:45 CST 2025