1. Indexing

Index is a data structure which is used to locate and fast access data in tables or views

  • Indexing helps reducing the amount of access to memory during query execution by establishing organized structures, adding db engine in promptly identifying rows that meet specified conditions in where clause.
  • Although indexing boosts the perfomance of queries, it will be a trade off for the write operations. So it