Enhance the speed of data retrieval by indexing

My journey to fix the issue with scalar subquery