indeksistruktuur
An indeksistruktuur, or index structure, is a data structure that improves the speed of data retrieval operations on a database table. Without an index, a database system must scan every row in a table to find the specific information requested by a query. This can be very slow, especially for large tables. An index works similarly to the index in a book. It contains a sorted list of values from one or more columns of a database table, along with pointers to the actual rows in the table where those values are located.
When a query is executed that includes a condition on an indexed column, the database can use
However, indexes are not without their drawbacks. They consume storage space and can slow down data modification