Indexing in MySQL

Why do we use indexes? Searching through a row in a sorted file with N length takes O(log2N) comparisons and the same number of reads from a filesystem which is heavy itself. However, tables in databases are not sorted which complicates the operation, Especially, if you have a lot of reads, updates and deletions on them. Writing […]

Begin typing your search term above and press enter to search. Press ESC to cancel.

Back To Top