Indexes in a database are analogous to indexes
that you find in a book. Indexes can help
queries to find data quickly in a database. An index is a data structure
(most commonly a B- tree) that stores the values for a specific column in a
table. An index is created on a column of a table. An index consists of column
values from one table, and that those values are stored in a data
structure. The index also stores
pointers to the table row so that other column values can be retrieved – read
on for more details on that. It is important to understand that a database
index does not store the values in the other columns of the same table.
No comments:
Post a Comment