Indexes are used to quickly locate data without having to search every row in a database table every time a database table is accessed. Indexes can be created using one or more columns of a database table, providing the basis for both rapid random lookups and efficient access of ordered records.
Results 16 to 17 of 17
Thread: What is the purpose of indexing?
-
06-22-2020, 06:07 AM #16Senior Member
- Join Date
- Dec 2019
- Posts
- 1,837
-
07-03-2020, 05:14 AM #17Registered User
- Join Date
- Aug 2018
- Posts
- 1,141
- An index is a pointer to a location of data.
- The purpose of an index is to make SQL queries run faster.
- If the optimizer detects an index that matches part of the WHERE clause of the query, then it uses the index to avoid having to read every row in the table.
Oryon Networks | Singapore Web Hosting | Best web hosting provider | Best web hosting in SG | Oryon india | Best hosting in India |Web hosting in India | Oryon SG
Reply With Quote
Posting Permissions
|
Bookmarks