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

how we can store the value like that 001,003,023 etc in sql server 2005

7 Answers  

How to invoke a trigger on demand?

0 Answers  

Can we linked SharePoint to a SQL database?

0 Answers   Sans Pareil IT Services,

What is function of CUBE ?

0 Answers   HCL,

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

0 Answers  

How to use column default values in insert statements in ms sql server?

0 Answers  

What are transactions and its controls?

0 Answers  

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the number of sales for each product

2 Answers  

How except clause is differs from not in clause?

0 Answers  

Explain system views?

0 Answers  

What is model database in sql server?

0 Answers  

What are the different types of triggers in SQL SERVER?

0 Answers