DEV Community

Cover image for What is Database Indexing?
Miahlouge
Miahlouge

Posted on • Edited on

What is Database Indexing?

Indexing is a database optimization technique that creates specialized lookup structures (B-Trees).

๐—œ๐—ป๐—ฑ๐—ฒ๐˜…๐—ถ๐—ป๐—ด ๐—ž๐—ฒ๐˜† ๐—•๐—ฒ๐—ป๐—ฒ๐—ณ๐—ถ๐˜๐˜€
โ†’ Fasts data retrieval by reducing search time
โ†’ Enables efficient lookup structures without altering original data
โ†’ Keeps the underlying data intact, ensuring data consistency
โ†’ Optimizes query execution paths for faster access

๐—œ๐—ป๐—ฑ๐—ฒ๐˜…๐—ถ๐—ป๐—ด ๐——๐—ถ๐˜€๐—ฎ๐—ฑ๐˜ƒ๐—ฎ๐—ป๐˜๐—ฎ๐—ด๐—ฒ๐˜€
โ†’ Increases storage requirements due to additional data structures
โ†’ Slows down write operations (INSERT, UPDATE, DELETE)
โ†’ Over-indexing can hurt more than help

Top comments (0)