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...

what is cluster and nin-cluster index?

Answer Posted / manisha

cluster index sorts the data ,so its affects the physical
arragement,while non clustered does not sorts the data.

a table can have max of 1 clustered index but can have upto
249 non clustered index.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between migration and upgradation in sql server?

1081


How to define the name and server for a new dsn?

1086


Why do we use functions?

895


What is the current limitation of the size of SQL Azure DB?

124


What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

967


if no size is defined while creating the database, what size will the database have? : Sql server administration

975


What is a ddl statement?

891


What is code near application topology?

279


What are the differences between user defined functions and stored procedures?

1049


What is a db view?

880


How do we Backup SQL Azure Data?

108


What is service broker? : sql server database administration

975


What does the not null constraint do?

1061


whats new about truncate in sql server 2008?

2486


Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

982