is it possible to have a primary key that is enforced with a bitmap index?
if so what is the syntax?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San
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]
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:
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
Yes, but you can enforce a PK constraint without a unique index. If you take
a look at the code, you'll see that my index is also nonunique.
Theoretically,
there shouldn't be much difference between non-unique indexes and bitmap
indexes. Practically, there is.
--
Mladen Gogala
Oracle DBA
-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 date) ;