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 |
What does sqlcabc has?
In a single table,How to retrieve a employee-id of an employee who works in more than one department?
Define declaration generator (dclgen).
Are view updateable?
What is load replace in db2?
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
What are data types?
What is the picture clause of null indicator variable?
What is deadlock?
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?
How to create db2 table in mainframe?
database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please