Question
· Sep 5, 2021

how to optimize a SQL query using Query plan

Hello everyone

 

I am new to cache. In an interview i was asked how to optimize a sql query.

I just said I will create index on conditions which are present in where clause. But as per interviewer I should check How query plan is getting executed. This will help in optimizing Sql queries. 

I want to know what will be the answer for how to optimize SQL query in cache. 

Thanks in advance!!

Product version: IRIS 2021.1
Discussion (2)1
Log in or sign up to continue