TechRxiv
G9_research_paper.doc (225.5 kB)
Download file

MySQL Select Query Optimization Using Self-Join

Download (225.5 kB)
preprint
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. 

Funding

Vedant Jain

History

Email Address of Submitting Author

vedantjainco19@acropolis.in

Submitting Author's Institution

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

Submitting Author's Country

  • India

Usage metrics

    Licence

    Exports