Use EXPLAIN to list out the access paths of several different codes you c

My SQL is not performing well. Describe how will you fine
tune it?

Question Posted / akbar

Answer Posted / akbar

Use EXPLAIN to list out the access paths of several
different codes you come up with and choose the path that
got executed within the least time.

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I change the column size in db2?

1153

Define predicate?

1130

How to find primary key of a table in db2?

1062

What is the physical storage length of date data type?

1252

Can you use max on a char column?

1096

Which component is used to execute the sql statements?

1095

What does db2 plan contain?

1019

can we view the access paths created by dbrm ? how ? thx

7090

What is node in db2?

1042

What is load utility in db2?

1181

What db2 400?

1183

What is an instance in db2?

1033

What are the 2 sqlcodes that are returned?

1187

What is query_cache_limit?

970

What is performance tuning db2?

1059