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

Where are stored procedures in sql server?

0 Answers  

Can I delete event logs?

0 Answers  

Explain the ways to controlling cursor behavior?

0 Answers  

How to delete existing rows in a table?

0 Answers  

How to retrieve data from log files in SQL SERVER ?????

1 Answers  

how many no of arguments can be passed in procedures and functions

1 Answers   ABC,

you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation

0 Answers  

How do I create a trace in sql server?

0 Answers  

How to choose all records from the table?

0 Answers  

Explain a join?

0 Answers  

List all types of constraints in sql server?

0 Answers  

What is coalesce in sql server?

0 Answers