answersLogoWhite

0

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.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

What might be caused by a clustered index?

A clustered index in a database can improve the retrieval speed of data, as it physically orders the rows of a table based on the indexed column or columns. It can also help reduce the amount of data pages that need to be read when querying data. However, because the data is physically ordered based on the clustered index column, updates to this column can be expensive.


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


Can you explain the process of how to drop an index in a database?

To drop an index in a database, you need to use a specific SQL command. First, you identify the name of the index you want to drop. Then, you use the DROP INDEX statement followed by the name of the index. This command removes the index from the database, making the associated data searchable without the index.


How index increase the performance of database?

Index on a table in the database is just like an index (or content page) in a book - a quick look at an index can tell you where the actual data is located. This saves time and cost of scanning the whole table, thus making the database faster.


Salient features of SQL?

Database Mirroring--> Extend log shipping capabilities with the database mirroring solution. You will be able to use database mirroring to enhance availability of your SQL Server systems by setting up automatic failover to a standby server. Online Restore--> With SQL Server 2005, database administrators are able to perform a restore operation while an instance of SQL Server is running. Online restore improves the availability of SQL Server because only the data being restored is unavailable; the rest of the database remains online and available. Online Indexing Operations--> The online index option allows concurrent modifications (updates, deletes, and inserts) to the underlying table or clustered index data and any associated indexes during index data definition language (DDL) execution. For example, while a clustered index is being rebuilt, you can continue to make updates to the underlying data and perform queries against the data. Fast Recovery--> A new faster recovery option improves availability of SQL Server databases. Administrators can reconnect to a recovering database after the transaction log has been rolled forward.


What are the basic concepts of a database management system?

This list could easily be expanded: Tables Columns Rows Data types Normalization 3rd normal form Primary key Foreign key Relationship Entity Relationship (ER) diagram Structured Query Language (SQL) Table joins Indexing Clustered index Secondary index Views


What serves as an index of office or records?

It is a database, either a manual card index or an electronic computer system.


What is another word for database?

The word database is a noun that means a collection of data. Some words that are synonyms for database are directory, index, and table.


Is a database software or hardware?

A database, as used by a computer, is a software programme that is used to store data (information). A card index is also a database, written on pieces of card - so, technically, a card index is a physical thing (hardware?), possibly.


What are the components of relational database?

Table, index, trigger and column Table, index, trigger and column


What are the ways of preventing duplicate values in a field?

Vague question, but if you are talking about a database field, the simple way is to create a unique index on the field (if the database supports it). The index will not allow duplicate values to be added to the database for that field and will generate an error if somebody tries.


What is used to uniquely identify a record in a database program?

index field