answersLogoWhite

0

When a clustered index (also known as data) is made, the SQL server will momentarily duplicate itself and sort the data from the heap into a clustered index key order.

User Avatar

Wiki User

11y ago

What else can I help you with?

Related Questions

What is clustered index in database?

The data is stored along side the index keys, so when a query searches by the index, once it's found the "leaf" in the index tree, it usually has gotten the data in the same disk read. So your searches by that key are much faster. The down-side is that it takes much longer to save data with a clustered index, because it has to make space where the key should be stored for the table data.


How many indexes can be created for a table?

1 Clustered and 249 Non Clustered 1 Clustered and 249 Non Clustered 1 Clustered and 249 Non Clustered


What is maximum number of non clustered index created in a table and in a database?

you can create max. 249 ncli in a table you can create max. 249 ncli in a table


What are the Usefulness of nearest-neighbor index?

The nearest-neighbor index measures how clustered or dispersed individual points are in a dataset. It is useful in spatial analysis to identify patterns of clustering or dispersion, assess the degree of spatial autocorrelation, and understand the spatial distribution of data points. A low nearest-neighbor index indicates clustering, while a high index suggests dispersion.


What is the meaning of clustered?

Clustered means to spread something and looks messy. For instance, "you clustered all that butter on the floor!"Clustered means the all of your points are in a small general location. Instead of being in wide expanded areas with outliers. In short, clustered means bunched up.


What did streets ville grow as a clustered settlement or linear or scattered settlement?

clustered settlement


Why does Angry Birds lag on phone?

Your phone might have a bit of a clustered memory. Try removing unnecessary things to speed it up.


What might have caused the wolfe creek crater?

A metorite might have caused the crater


What might have caused wolfe creek crater?

A metorite might have caused the crater


In East Asia where is most of the population clustered?

In east Asia, the population is clustered along the coasts and rivers.


What does the term clustered mean?

Clustered is a word that means to be together or situated into a group. Some synonyms of the word are bunched, group, bunch, flock, or clump. Clustered together refers to a group of something.


What sampling technique will be the best for the large population size?

Clustered sampling.Clustered sampling.Clustered sampling.Clustered sampling.