I have a query which involves a table and a function. Table has got around 59 crores of records and the function returns 56k records. There is a inner join between with function being on the left side. This query takes around 2 minutes to execute. I wanna
improve the performance to few seconds.
I made sure that the table has all required indexes but still was not able to improve the performance.
Please suggest what else i can do to improve performance.
View Complete Post