answersLogoWhite

0

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.

User Avatar

Wiki User

10y ago

What else can I help you with?

Related Questions

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.


Supplier performance index?

Considers costs associated with supplier nonperformance


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 manages the security of the database check backup and recovery procedures and monitors the performance of the database?

Database administration


What is index in sql?

Index is a data structure that improve the performance of data.


What is the current performance of the ABX subprime index?

The current performance of the ABX subprime index is fluctuating due to market conditions.


What are the components of relational database?

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


How do you increase Windows Experience Index in Windows Vista?

The Experience Index can be increased by upgrading the lowest-scoring component on the lists. For example, if you scored badly in graphics performance, you would need to purchase a better graphics card.


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