What Would You Do When A User Or Users Are Complaining That A Particu

1.	What Would You Do When A User Or Users Are Complaining That A Particular Query Is Running Slow?
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

What Would You Do When A User Or Users Are Complaining That A Particular Query Is Running Slow?

Answer»