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

List out different types of normalizations in sql server and explain each of them?

888


How do I get to sql server configuration manager?

953


What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

951


What xml support does the sql server extend?

958


What is statement level trigger?

938


What is report rendering ?

149


What is a mixed extent?

955


How do I port a number to sql server?

983


How to return the top 5 rows from a select query in ms sql server?

1076


what stored procedure would you use to view lock information? : Sql server administration

929


What is the most common type of join?

914


Why truncate is ddl command?

995


How to convert a numeric expression from one data type to another?

934


What is de-normalization and what are some of the examples of it?

927


Differentiate between SQL and ORACLE joins and write their syntax.

981