How Would Go About Query Tuning?

1.	How Would Go About Query Tuning?
Answer» LOOK at the query plan Look at the stats of the table/tables in the query look at the table distribution keys and joins in the query look at the NETWORK performance look at the resource queues look at the INTERCONNECT performance look at the join ORDER of tables in the query look at the the query itself i.e. if it can be written in more EFFICIENT way

Answer»

Discussion