Q1Suppose you have this query SELECT Pname Price Color FROM

Q1.Suppose you have this query

SELECT Pname, Price, Color

FROM PRODUCT

WHERE Price < 50 OR Color = ‘Red’;

Which technique can be used to improve this query ?

Q1.Suppose you have this query

SELECT Pname, Price, Color

FROM PRODUCT

WHERE Price < 50 OR Color = ‘Red’;

Which technique can be used to improve this query ?

Solution

Answer:

Here we need to check for indexes , remove unnecessary feilds and tables. Also remove calculations in where clause. The best technique to improve the queries is .