1. Clustered Index 2. Non-Clustered Index

What are the type of Indexes? which one is best, why?

Question Posted / s. sundar

Answer Posted / s. sundar

1. Clustered Index
2. Non-Clustered Index

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Name few of the dcl commands in sql?

975

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

1131

Can we write ddl in trigger?

887

Do you know what is normalization of database? What are its benefits?

1061

Some queries related to SQL

943

What is delete query?

915

How do I open a .db file?

990

Do you know the cursor types?

1129

How many types of functions are there in sql server?

900

What is the use of nvl work?

966

what types of replication are supported in sql server? : Sql server database administration

983

What does the not null constraint do?

1026

What is the difference between web edition and business edition?

111

What will happen if a column containing char type data is changed to the nchar data type?

1062

What are the general features of sql server management studio? : sql server management studio

1039