G9_research_paper.doc (225.5 kB)
Download file

MySQL Select Query Optimization Using Self-Join

Download (225.5 kB)
posted on 2023-03-27, 05:47 authored by Vedant JainVedant Jain

 The challenge of query execution in MySQL involves the efficient and accurate processing of SQL queries to retrieve, manipulate, and store data in a database. It requires optimizing the query execution plan, identifying and resolving performance issues, and ensuring data integrity and security. The challenge lies in balancing the trade-offs between query complexity, database size, system resources, and user requirements. Choosing the right approach depends on the specific characteristics of the data and workload. Therefore, in this paper, we have applied various techniques to get optimized results. 


Vedant Jain


Email Address of Submitting Author

Submitting Author's Institution

Acropolis institute of technology and research, Indore (M.P.), India

Submitting Author's Country

  • India

Usage metrics