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 are the recovery models for a database?

0 Answers  

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

0 Answers   Accenture,

Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

0 Answers  

How to replace the Query Result 'Null Value' with a text ?

0 Answers   MCN Solutions,

Does full backup break log chain?

0 Answers  

What are the different types of joins and what does each do?

2 Answers  

Write query to return all rows sql?

0 Answers  

In what sequence sql statement is processed?

0 Answers  

What is the library index called?

0 Answers  

How to convert numeric expression data types by assignment operations?

0 Answers  

How do you manipulate data?

0 Answers  

How many types of attribute relationships are there? : sql server analysis services, ssas

0 Answers