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?



What is sorting and what is the difference between sorting and clustered indexes?..

Answer / 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

More SQL Server Interview Questions

How to insert multiple rows with a subquery?

0 Answers  


What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....

9 Answers   DELL, i Tech, Infosys, Siemens, TCS,


How to select some specific rows from a table in ms sql server?

0 Answers  


How do SQL server 2000 and XML linked?

2 Answers  


In which files does sql server actually store data?

0 Answers  


what is the difference between sql query and google query?

10 Answers   TCS,


Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

0 Answers  


What is the difference between indexing and hashing?

0 Answers  


Can an automatic recovery be initiated by a user?

0 Answers  


How does clustered and non clustered index work?

0 Answers  


How to truncate the log in sql server 2012? : sql server database administration

0 Answers  


How to add code to the existing article (using improve article)?

0 Answers  


Categories