Which index gets automatically created with primary key?
a) B-tree Index
b) Bitmap Index
c) Funcation Based Index
d) Index never create automatically
Reg: Indexing
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The answer is different with different database products, and you left out the possibility of "none". Most usual, I guess, would be a b-tree index. But there are certainly other possibilities. And in some cases it is possible to change that decision subsequently. For example in Red Brick if a STAR index includes all key columns, then the B-tree index on the primary key can never be used and so would be able to be dropped.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.