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 to download and install the scaled-down database adventureworkslt?

0 Answers  

what is a correlated sub-query? : Sql server database administration

0 Answers  

last function used in MS Access to convert sql what function will use in sql

0 Answers   Cap Gemini,

What are 3 ways to get a count of the number of records in a table?

0 Answers  

How to list all columns in a table using odbc_columns()?

0 Answers  

Tell me about joins in database system and explain each in detail.

0 Answers   Axtria, ITC Indian Tobacco Company,

How you would rewrite the sql query to return the customerid sorted numerically?

0 Answers  

How to drop an existing table?

0 Answers  

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

0 Answers  

explain different types of jions with examples briefly?

1 Answers   Zensar,

How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.

1 Answers  

where do you use Isolations?give me some exmpale?

1 Answers