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 are the types of indexes available with SQL Server?

Question Posted / guest

Answers were Sorted based on User's Feedback



What are the types of indexes available with SQL Server?..

Answer / guest

There are basically two types of indexes that we use with
the SQL Server. Clustered and the Non-Clustered.

Is This Answer Correct ?    12 Yes 1 No

What are the types of indexes available with SQL Server?..

Answer / nagabhushan

Indexes are of two types,Clustered Index and non Clustered
Index,when you create Clustee index on tables all the rows
in the tables are stored in the order of the clustered
Index key,So there will one cluster index in the table.Non
Clustered Index have there own storage seperate from the
table data storage.Non Clustered Index is stored in the
form of B-trees.

Is This Answer Correct ?    8 Yes 1 No

Post New Answer

More SQL Server Interview Questions

What happens if null values are involved in datetime operations?

0 Answers  

What is named calculation? : sql server analysis services, ssas

0 Answers  

plz send every query in sql server2000

1 Answers   Infosys,

Explain mixed authentication mode of sql server?

0 Answers  

Do you know what is user defined datatypes and when you should go for them?

0 Answers  

What are the types of database recovery models?

0 Answers   HCL,

What is save transaction and save point?

0 Answers  

What are the steps to take to improve performance of a poor performing query? : sql server database administration

0 Answers  

how to invoke a trigger on demand? : Sql server database administration

0 Answers  

What are different types of raid configurations? : SQL Server Architecture

0 Answers  

How do I open port 1433?

0 Answers  

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories