> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
> [EMAIL PROTECTED]
>
> is it possible to have a primary key that is enforced with a
> bitmap index?
I don't think so. Here's an example from a 9.2.0.3 database:
SQL> create table t (v varchar2 (10), d d
Oracle DBA
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of Khedr, Waleed
> Sent: Tuesday, September 23, 2003 5:50 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: possible to have a primary key with a bitmap indx?
>
>
Restrictions on Unique Indexes
You cannot specify both UNIQUE and BITMAP
-Original Message-
Sent: Tuesday, September 23, 2003 5:35 PM
To: Multiple recipients of list ORACLE-L
It's not possible:
SQL> create bitmap index emp_empno_b on emp(empno);
Index created.
SQL> alter table emp a
It's not possible:
SQL> create bitmap index emp_empno_b on emp(empno);
Index created.
SQL> alter table emp add constraint emp_pk primary key(empno) using index
emp_empno_b novalidate;
alter table emp add constraint emp_pk primary key(empno) using index
emp_empno_b novalidate
*
ERROR at line 1:
A bitmap index is for a low cardinality column, so I doubt it would be a
good idea to use it to enforce a primary key.
Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 499-7999 7470 and (514) 925-7187
[EMAIL PROTECTED]