Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / saravakumar


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

What do you mean by sql server 2005 express management tools?

0 Answers  

What is the difference between a stored procedure and a user defined function in sql server?

2 Answers   Millennium,

How does stuff differ from the replace function?

0 Answers  

what is difference between NULL and ISNULL in SQL Server 2008?

0 Answers   MCN Solutions,

What are the pros and cons of creating extended stored procedures?

1 Answers  




Explain ranking functions?

0 Answers  

how to know Who Is Blocking Your SQL Server?

4 Answers  

How do I start sql server?

0 Answers  

How do indexes help, types?

0 Answers  

What is create statement?

0 Answers  

what is difference between Enterprise Manager and Query Analyer

6 Answers   CTS,

Explain difference between control flow and data flow?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories