Answer / arun pandey

Hi

1)Clustered Index
2)NON-Clustered INdex

But Clustered index is better than non-clusted
becoz the searching in clusterd is faster than non-clustered

Arun Pandey
A1Technology

Answer / s. sundar

1. Clustered Index
2. Non-Clustered Index

Answer / jeff jordan

1) Clustered Index
2) Non-Clustered Index

I'm assuming by "which one is best" we mean which has the
faster look ups. This would be the clustered index since it
is the physical ordering of the rows and the non-clustered
index is like a lookup table. With the clustered index one
you've found the index you've found your row...

Answer / amit choubey

clusterd and non clusterd

Answer / jay vardhan singh

Cluster is faster then non cluster index.We can use only
one cluster index on one table and we can use more then one
non cluster index on one table.

Answer / a.ganesh

not only two type, more type of indexes there
such as Clustered Index with Primary And Index with Uniqu

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

1 Answers  

internal language used in sql server 2000?

2 Answers  

How to use old values to define new values in update statements in ms sql server?

0 Answers  

What are window functions in sql server?

0 Answers  

How to receive output values from stored procedures?

0 Answers  

Do you know what is user defined datatypes and when you should go for them?

0 Answers  

Can we rewrite subqueries into simple select statements or with joins? Example?

2 Answers   ASD Lab,

What is normalization? What number of normalization shapes are there?

0 Answers  

What are the built in functions in sql server?

0 Answers  

What is transaction server explicit transaction?

0 Answers  

Explain in brief about Microsoft SQL server?

0 Answers  

What is 'Join' and explain its various types.

0 Answers   Genpact,