I have two tables: TABLE1 and TABLE2.
And I am running this
select query to fetch the data. It takes long time to run:
SELECT TABLE1.* , TABLE2.COL1 , TABLE2.COL4 FROM TABLE1, TABLE2 WHERE TABLE1.COL1 IN ('1','TEXT','HO TED') AND TABLE1.COL2= 1800 AND TABLE2.COL1 = 10519198 AND TABLE1.COL3>= 100 AND TABLE1.COL4= TABLE2.COL2 AND TABLE2.COL3=('TEXT')
How could I improve the performance of this select query? Does too many
AND affect my performance?