Question

How Is Index Tuning Used To Improve Query Performance?

Answer 1

• Follow the SQL best practices to ensure query optimization:
• Index all the predicates in JOIN, WHERE, ORDER BY and GROUP BY clauses. ...
• Avoid using functions in predicates. ...
• Avoid using wildcard (%) at the beginning of a predicate. ...
• Avoid unnecessary columns in SELECT clause. ...
• Use inner join, instead of outer join if possible.

• pls click brainlylist