Types of indexes. What is the default key created when a
primary key is created in a table ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can the performance of a trigger be improved?

774


What is mdf ldf and ndf?

744


How to avoid using cursors? What to use instead of cursor and in what cases to do so?

868


What is the sql*loader? : aql loader

779


what are all the different types of indexes? : Sql dba

717






What are analytical functions in sql?

730


What is information schema in sql?

763


How is data stored in sql?

728


What are different types of statements supported by sql?

821


what are the join types in tsql? : Transact sql

755


What are the possible values that can be stored in a boolean data field?

717


What is write ahead logging in sql server?

748


What are the different operators available in sql?

747


what is sp_pkeys? : Transact sql

889


What is the life of an sql statement?

720