Basic Indexing Techniques in Relational Database

  • Unique Paper ID: 149361
  • Volume: 6
  • Issue: 12
  • PageNo: 135-137
  • Abstract:
  • Indexing is a data structure technique to efficiently retrieve records from the database files based on some attributes on which the indexing has been done. Indexing is used to optimize the performance of a database by minimizing the number of disk accesses required when a query is processed. This work focuses on various indexing methods used in RDBM files to enhance and optimize the query processing.

Copyright & License

Copyright © 2025 Authors retain the copyright of this article. This article is an open access article distributed under the Creative Commons Attribution License which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.

BibTeX

@article{149361,
        author = {Vinitha C and Saumya Unnikrishnan and Jinesh V N},
        title = {Basic Indexing Techniques in Relational Database},
        journal = {International Journal of Innovative Research in Technology},
        year = {},
        volume = {6},
        number = {12},
        pages = {135-137},
        issn = {2349-6002},
        url = {https://ijirt.org/article?manuscript=149361},
        abstract = {Indexing is a data structure technique to efficiently retrieve records from the database files based on some attributes on which the indexing has been done. Indexing is used to optimize the performance of a database by minimizing the number of disk accesses required when a query is processed. This work focuses on various indexing methods used in RDBM files to enhance and optimize the query processing.},
        keywords = {Indexing, Dense indexing, Sparse Indexing},
        month = {},
        }

Cite This Article

  • ISSN: 2349-6002
  • Volume: 6
  • Issue: 12
  • PageNo: 135-137

Basic Indexing Techniques in Relational Database

Related Articles