EUVIMEDEUVIMED entdecken
Open Access · CC BY 4.0

Analyzing the Relationship Between Data Size Indexing and Query Response Time in Relational Database Systems

Hassan Bediar Hashim

International Journal of Computational and Applied Mathematics & Computer Science · 10.06.2026 · 33

DOI: 10.37394/232028.2026.6.4 ↗

Kurz gefasst

Fachartikel in der Zeitschrift International Journal of Computational and Applied Mathematics & Computer Science, online erschienen am 10.06.2026. Verfasst von Hassan Bediar Hashim. Die Arbeit nennt 18 Literaturangaben. Der Volltext ist frei zugänglich (Open Access, CC BY 4.0).

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

In the context of Relational Database Management Systems (RDBMSs), we investigate how data size and index strategies affect query response time. With the explosive increase of data, efficient data processing and user satisfaction are highly dependent on the performance of database. Response Time is the major indicator of the performance being experienced. The study is conducted with an analytical method through performance evaluation experiments in which query execution times are measured for several size datasets with indexed and non-indexed configurations (none, B-Tree, Hash). Anyway, for large dataset, we would take Cost-Based Optimization (CBO) into consideration the optimize execution plans (i.e., adaptive or learned indexing). The response time for the above query is a strong function of data size (positive correlation) and degradation is large in case of no indexing. Correct indexing can hugely reduce response time; we estimate at a figure of around 35– 60%. ((Note that B-Tree indexing works comparably or better on various workloads: response times for heavy workloads are 40–45% baseline on B-Tree as opposed to 55–60% in the case of Hash.) This process highlights the importance of proper indexing strategies for both performance and scalability, as well has having useful implications on database design principles as well in data-intensive applications.

Zitieren

APA

Hashim, H. B. (2026). Analyzing the Relationship Between Data Size Indexing and Query Response Time in Relational Database Systems. International Journal of Computational and Applied Mathematics & Computer Science, 33. https://doi.org/10.37394/232028.2026.6.4

Vancouver

Hashim HB. Analyzing the Relationship Between Data Size Indexing and Query Response Time in Relational Database Systems. International Journal of Computational and Applied Mathematics & Computer Science. 2026:33. doi:10.37394/232028.2026.6.4

BibTeX
@article{Hashim2026,
  author = {Hashim, Hassan Bediar},
  title = {Analyzing the Relationship Between Data Size Indexing and Query Response Time in Relational Database Systems},
  journal = {International Journal of Computational and Applied Mathematics & Computer Science},
  year = {2026},
  pages = {33},
  doi = {10.37394/232028.2026.6.4}
}
Kostenlos starten →