Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is Index ? Explain its Types?

Question Posted / mohamed ibrahim

Answers were Sorted based on User's Feedback



What is Index ? Explain its Types?..

Answer / sajjan singh

Indexes are data structures that help SQL Server to find
particular rows of data fastly.

In a database, an index allows the database program to find
data in a table without scanning the entire table.
An index in a database is a list of values in a table with
the storage locations of rows in the table that contain each
value.
Indexes can be created on either a single column or a
combination of columns in a table and are implemented in the
form of B-trees.

Clustered Index: "A clustered index is a special type of
index that reorders the way records in the table are
physically stored.
Therefore table can have only one clustered index. The leaf
nodes of a clustered index contain the data pages."

Non Clustered Index: "A nonclustered index is a special type
of index in which the logical order of the index does not
match the physical stored order of the rows on disk.
The leaf nodes of a nonclustered index does not consist of
the data pages. Instead, the leaf nodes contain index rows."

Is This Answer Correct ?    3 Yes 0 No

What is Index ? Explain its Types?..

Answer / dinesh rathod

Index is a one important concept in .Net. So you should know the basic idea about index in .Net.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SQL Server Interview Questions

what is blocking? : Sql server database administration

0 Answers  

How to download and install microsoft .net framework version 2.0?

0 Answers  

How can sql server instances be hidden? : sql server security

0 Answers  

Why do you want to join software field as you have done your BE in Electronics?

0 Answers   Cap Gemini, HCL,

how to copy sysdatabase file from c: Drive to D: Drive in SQL Server.

6 Answers   IBM,

What does it mean if @@cursor_row returns a negative number?

0 Answers  

How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?

1 Answers  

What is meant by referential integrity?

0 Answers   Blue Star,

what is the disadvantage of SQL Loder?

1 Answers   TCS,

What is compression - row-level and page-level compression?

0 Answers  

Is sql server implemented as a service or an application? : Sql server database administration

0 Answers  

What is instead of trigger sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories