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 sorting and what is the difference between sorting
and clustered indexes?

Answer Posted / saravakumar

The ORDER BY clause sorts query results by one or more
columns up to 8,060 bytes. This will happen by the time when
we retrieve data from database. Clustered indexes physically
sorting data, while inserting/updating the table.

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to control the amount of free space in your index pages? : Sql server database administration

1020


List some case manipulation functions in sql?

1008


Where the sql logs gets stored? : sql server database administration

945


What does it mean to normalize a database and why would you do it?

967


I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

1127


What are the mathematical functions supported by sql server 2005?

1046


What is table valued function and scalar valued functions?

1059


How much memory that we are using in Logshipping Concept?

1772


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

1050


Which sql server table is used to hold the stored procedure scripts?

1051


Delete duplicate rows without using rowid.

1527


What to check if a User database is locked?

1049


Why do we use functions?

895


What is the difference between stored procedure and functions?

1110


How do I view a procedure in sql server?

978