Types of indexes. What is the default key created when a
primary key is created in a table ?
Answers were Sorted based on User's Feedback
Answer / mahesh
Major indexes are B-tree and Bitmap indexes
When ever we create a primary key, B-tree index will be
created
Is This Answer Correct ? | 15 Yes | 3 No |
Answer / sdp
A unique index is created when a primary key is created in
a table.
Is This Answer Correct ? | 10 Yes | 3 No |
Answer / suren
while creating primary by default a unique index is created
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / manish_patil
There are main two types of indexes,
B-tree index
Bitmap index.
While creating Primary key by default cluster index get
crated.
Is This Answer Correct ? | 7 Yes | 5 No |
Is join same as left join?
Why do we need a foreign key?
What is mdf ldf and ndf?
Explain the advantages and disadvantages of stored procedure?
Maximum how many triggers can we use in trigger and How to find out how many records it fetched.
how to convert dates to character strings? : Sql dba
How many commands are in sql?
How do I run a pl sql program?
which types of join is used in sql widely? : Sql dba
write a query to find 4th max salary
What is sql and its types?
What is the use of function "module procedure" in pl/sql?