How a database index can help performance?

Technology CommunityCategory: SQLHow a database index can help performance?
VietMX Staff asked 3 years ago

The whole point of having an index is to speed up search queries by essentially cutting down the number of records/rows in a table that need to be examined. An index is a data structure (most commonly a B- tree) that stores the values for a specific column in a table.