Virat Sharma · 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
1 0 2 107
Log in or sign up to continue

Beginners see the query plan first and then create the index on items in WHERE clause.
Experts mostly reverse the sequence.