Home » SQL & PL/SQL » SQL & PL/SQL » Create Bitmap index on primary key
Create Bitmap index on primary key [message #435632] Thu, 17 December 2009 02:50 Go to next message
sunil.madnani
Messages: 36
Registered: March 2007
Location: BHILAI
Member
Hello Gurus,

I want to create Bit map index on primary key column of a table.Is it possible? and i am getting an error ora-00439.

e.g.

create table empdtls( emp_id number primary key,
emp_name varchar2(200));

create bitmap index b_ind on empdtls(emp_id);

I want to know is the right way to create bitmap index or not.


Regards:
Sunil Madnani
Re: Create Bitmap index on primary key [message #435635 is a reply to message #435632] Thu, 17 December 2009 03:00 Go to previous messageGo to next message
pablolee
Messages: 2813
Registered: May 2007
Location: Scotland
Senior Member
You don't want to do that. A primary key is a VERY poor candidate for a Bitmap index. Think of a different way. (I would also suggest that you read and understand the documentation before attempting to implement a feature that you have little knowledge of).
In addition, a simple and very quick google would have given you:

Quote:
ORA-00439: feature not enabled: string
Cause: The specified feature is not enabled.

Action: Do not attempt to use this feature.



I would say that this is pretty obvious.

[Updated on: Thu, 17 December 2009 03:02]

Report message to a moderator

Re: Create Bitmap index on primary key [message #435637 is a reply to message #435632] Thu, 17 December 2009 03:26 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Do you know, the purpose of bit-map index?
Does it match with primary key attribute?

Normally, Primary keys are designed for uniqueness of values.
While on the other hand, bitmap indexes are used for duplicate vaules...

Just go through the above link.

regards,
Delna
Re: Create Bitmap index on primary key [message #435913 is a reply to message #435632] Fri, 18 December 2009 21:14 Go to previous message
Kevin Meade
Messages: 2098
Registered: December 1999
Location: Connecticut USA
Senior Member
Once again we have a an error message but not text. I have no desire to look the error up.

Why did you take the time to write a post to us, give us an error number, but then not take the time to give us the text of the message?

One of my peeves! Kevin
Previous Topic: Stored procedure (merged 3)
Next Topic: number to char
Goto Forum:
  


Current Time: Tue Sep 27 05:58:04 CDT 2016

Total time taken to generate the page: 0.11636 seconds