Home » RDBMS Server » Server Utilities » question
question [message #69493] Mon, 21 January 2002 12:11 Go to next message
karen
Messages: 19
Registered: January 2002
Junior Member
hi,
why bitmap index can't be unique??????????????????
please explain.
thanx
Re: question [message #69505 is a reply to message #69493] Tue, 22 January 2002 10:15 Go to previous message
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 Mar 28 14:22:05 CDT 2024