|
Explain the impact of indexing on data access.Databases indexes are used to improve the speed of operations on database tables. Indexes are created using one or more fields of a table. Indexes take lesser space than the actual tables, however as a result increasing data availability and database operations performance. Once can even create indexes on functions. Absence of index needs a query to scan through every record of a table to match and retrieve relevant records, whereas, with the help of indexes, the computational cost for providing the same result can be much lesser based on the indexing technique used, e.g.: Balanced trees, B+ trees and hashes.
|
