adspace


How many types of indexes are there in sql?

Answer Posted / Kirti Chauhan

There are five types of indexes in SQL: 1) Clustered Index, 2) Non-Clustered Index, 3) Primary Key Index (which is a type of Clustered Index), 4) Unique Index, and 5) Full Text Index.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is bcp? When does it used? : Sql dba

1065


define sql insert statement ? : Sql dba

1110


how to use regular expression in pattern match conditions? : Sql dba

1125


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2102


Does group by remove duplicates?

1120


Is inner join faster than left join?

1287


what are aggregate and scalar functions? : Sql dba

1142


Can we use distinct and group by together?

1146


Can delete statement be rollbacked?

1065


What is the current version of sql?

1106


how many tables will create when we create table, what are they? : Sql dba

1156


what is dbms? : Sql dba

1070


Can we rollback truncate?

1083


If a cursor is open, how can we find in a pl/sql block?

1252


what are all the common sql function? : Sql dba

1141