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

How many index can be created for single table

Question Posted / sanjay kumar dinda

Answer Posted / sanjay kumar dinda

Two types of indexes are there in SQL Server
1. Clustered Index
2. Non-Clustered Index

We can create only 1 Clustered index in a table as it re-
orders the data of the table
We can create upto 249 Non-Clustered index in a table...

Is This Answer Correct ?    17 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we use max in where clause?

886

What is the maximum size of a row in sql server?

919

What is the query and subquery?

1031

Can group by be used without aggregate functions?

862

What are scheduled tasks in sql server?

1020

What is the difference between the application object and session object?

1022

Define master database?

1000

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

895

What is tcl in sql server?

1082

What is query and its types?

878

What is triggers and stored procedures?

902

Explain what is the difference between union and union all?

959

Explain the concept of recursive stored procedure.

889

What is a constant or literal in ms sql server?

1001

What is the exact numeric data type in sql?

968