Hello,

For percormance tunning u have to see the explain plan of the query in sql.

There are different parts through we can modifies the queries performance like

which way the query is...