What is the difference between a clustering index and a secondary index?

Asked by Last Modified  

3 Answers

Learn MS SQL

Follow 2
Answer

Please enter your answer

Online Mathematics tutor with 8 years experience(Online Classes for 10th to 12th)

Secondary indexes can exist multiple times for a database and clustering indexes help with data clustering and improve data retrieval speed.
Comments

"Rajesh Kumar N: Guiding Young Minds from 1 to 12 with Expertise and Care"

A clustering index sorts the data rows in the table based on the index, while a secondary index is a non-clustered index that creates a separate structure for faster searches without changing the data order.
Comments

I am online Quran teacher 7 years

A clustering index sorts the data rows in the table based on the index, while a secondary index is a non-clustered index that creates a separate structure for faster searches without changing the data order.
Comments

View 1 more Answers

Related Questions

What are the everyday activities of an SQL queries for MIS Excecutive ?
For MIS executive, your everyday activity could be select the data, Insert the data, update the data and delete the data as well. Please make sure took table backup OR use Begin trans, Commit trans &...
Siddu
0 0
5
In how many days can i learn sql server dev.?
If saturday and sunday class then within 2 month. means 36 hours u can learn properly SQL Development course.
Glen

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

SQL And or Operator
SQL AND & OR Operators The AND & OR operators are used to filter records based on more than one condition. The SQL AND & OR Operators The AND operator displays a record if both the first...

Rename The Logical Name Of SQL Server Database Files Using T-SQL
Rename the logical name of SQL Server database files using T-SQL: 1. Problem: SQL Server database files have two names: one is the logical file name and the other is the physical file name. The logical...

History of SQL server
In 1988, Microsoft released its first version of SQL Server. It was designed for the OS/2 platform and was developed jointly by Microsoft and Sybase. During the early 1990s, Microsoft began to develop...

R programming language
R is a programming language and software environment for statistical computing and graphics supported by the R Foundation for Statistical Computing. The R language is widely used among statisticians and...

An Introduction to Business Intelligence Concepts
Looking for a Business Intelligence (BI) solution for your company can be intimidating. BI uses its own special terminology and the database design concepts can be difficult to grasp. So where do you...

Recommended Articles

Almost all of us, inside the pocket, bag or on the table have a mobile phone, out of which 90% of us have a smartphone. The technology is advancing rapidly. When it comes to mobile phones, people today want much more than just making phone calls and playing games on the go. People now want instant access to all their business...

Read full article >

Business Process outsourcing (BPO) services can be considered as a kind of outsourcing which involves subletting of specific functions associated with any business to a third party service provider. BPO is usually administered as a cost-saving procedure for functions which an organization needs but does not rely upon to...

Read full article >

Software Development has been one of the most popular career trends since years. The reason behind this is the fact that software are being used almost everywhere today.  In all of our lives, from the morning’s alarm clock to the coffee maker, car, mobile phone, computer, ATM and in almost everything we use in our daily...

Read full article >

Whether it was the Internet Era of 90s or the Big Data Era of today, Information Technology (IT) has given birth to several lucrative career options for many. Though there will not be a “significant" increase in demand for IT professionals in 2014 as compared to 2013, a “steady” demand for IT professionals is rest assured...

Read full article >

Looking for MS SQL Training?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you