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



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

Answer / 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

Post New Answer

More DB2 Interview Questions

What does sqlcabc has?

0 Answers  


In a single table,How to retrieve a employee-id of an employee who works in more than one department?

15 Answers   Cap Gemini,


Define declaration generator (dclgen).

0 Answers  


Are view updateable?

0 Answers  


What is load replace in db2?

0 Answers  






One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?

3 Answers  


What are data types?

2 Answers  


What is the picture clause of null indicator variable?

0 Answers  


What is deadlock?

2 Answers  


What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?

1 Answers  


How to create db2 table in mainframe?

0 Answers  


database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please

1 Answers  


Categories